I have created an SSIS package in SQL Server 2008 that is required to iterate through a table that contains the ID, location to output files, spname to execute and contains data for each clientID with
I am using SSIS (SQL Server 2008) to lookup values from a table. I wanted to know if the following are possible:
I\'m using SSIS with SQL Server 2005, I want to pass a data set as a parameter into a sproc. Inside the sproc, I have to process the records and insert into some destination table.
I am writing a basic file dump from one database to another. I am using SSIS 2008 and creating several packages to transform the data I have from a MSSQL 2010 database to a MYSQL 5.1 database.
I want to be able to do the following: Import a flatfile row by row Do a conditional split on a column value of each row
I am using SSIS (VS 2008) and I want to take a populated resultset variable (populated from an EXECUTE SQL task) and convert within an SSIS Script Component (c#) it into an array.
Every morning we receive a Zipped folder called Statistics.tar.gz (downloaded via ftp server) which contains 200 text files with today and yesterday date appended to each file name such :
I\'ve inherited a .NET app to support / enhance which reads in a couple of files of high hundreds of thousands of rows, and one of millions of row.
In many of our SSIS data flows across pa开发者_开发技巧ckages we call into a service of some kind from a script transform. I would like to promote reuse by eliminating web service related code and obj
I have a SSIS 2008 project and would like t开发者_运维技巧o write UnitTests for individual packages with VS2010. The reason for this is that we have a VS2010 Db project with stored procedures, functio
加载中,请稍侯......