How to debug开发者_StackOverflow中文版 SSIS Package - SQL 2008? I am calling the package from C# Code. But the package is not executing. I want to debug the SSIS Package and trace the paramter values.
I have read that a staging table should be an exact column by column mat开发者_如何学Cch of its target table in the dw. If that is the case, after populating the staging table is it best practice to n
I have a problem to transfer 800,000 records using SSIS into Sharepoint List Destination. SSIS is still running, but it takes one day and it can only transfer 20,000 record. So, here we have a time
I have a database table with about 700 millions rows plus (growing exponentially) of time based data.
I\'m trying to run a SQL Agent Job with a step that is a SSIS File, and I need this step to be run as administrator.
VS 2008 / SQL 2008 I am importing .csv file to SQL Table. I want to pass dynamically the Source File and Destination Connection string from C# Code.
I am writing to a flat file destination in a 2008 SSIS package.99.99% of it works correctly.However, I get one duplicate record in the destination file.
I have a table called Employees: BeginYear|EndYear|Name 19741983Robert For 开发者_如何学Pythoneach record in Employees I need to insert each year into a new table called EmployeeYears
SQL 2005 I am importing .csv file to SQL Table through SSIS Package !! On doing so, I am getting double quotes on ev开发者_开发知识库ery column header or field value !!
I want to read the resultset of a table using the following stmt: Select col1 as A,col2 as B from tablename;
加载中,请稍侯......