I have a recursive hierarchy in a relational database, this reflects teams and their position within a hierarchy.
I am 开发者_如何转开发used to DTS Pkgs where i can just write to a text file using a data transform task.
I want to be able to have a sql query in my DTSX package and I want to be able to have some sort of prompt to update the value of a null column. See what I have below:
Using SSIS 2008 R2, I have an OLE DB source with around 30 fields.Ultimately my destination is an Excel spreadsheet however I have a number of transformations along the way, including Lookups, Derived
In an SSIS data-flow task, I\'m using a Multicast transform at a key part of the flow which I want to hang a File Output destination off.
I am running Visual Studio 2010 Ultimate -- wh开发者_运维百科ich integrates with TFS source control.However, when I run SQL Server 2008 Business Inteligence Studio, no source control is offered.When I
In my Flat File source, i have all the columns mapped to output columns with the right type and all. After retriving the data, i check if the reference contained in the file exists in the database, i
Hi I am getting this error in my SSIS packages on alternate days An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.The AcquireConnection method call to the connectio
Anyone know how I can change开发者_StackOverflow社区 a SSIS variable at runtime? I have a variable User:SkipStuff
I am开发者_JAVA百科 generating a flat text file via an SSIS package. The package reads data from a table, creates a fixed length text file and ftp\'s the file to a partner.
加载中,请稍侯......