I have inherited a SSIS project. I have never worked with SSIS before, and the one thing that seems strange to me, is that there is no way to manage multiple configurations.
How can i Load Temptable on Server B by reading data from Server A in Dataflow task. alt text http://img开发者_运维知识库405.imageshack.us/img405/7127/temptable.gifThe short answer is don\'t do it. S
I have simple SSIS package where I import data from flat file into SQL Server table (SQL Server 005). File contains 70k rows and table has no primary key. Importing is sucessful but when I open SQL Se
I have simple package which reads data from csv file and loads into SQL table. File is located on another server and it is shared. I use UNC path in package. package is scheduled using sql agent job.
I\'m trying to add a simple configuration to a SSIS package, of type SQL Server, so stored in a table. At the end of the wizard, when it goes to try and write a new row to the nominated table to store
Alright SSIS got me. I have Database A source and Database B target. I am taking data form a table in A and transfering it to the same table in B. This is ok. However I have a createdbyUSer column in
How can I pass parameters in an OLE DB Source to call a table-valued function like: select * from [dbo].[udf_test](?, ?)
I have a challenge that I am trying to solve and I can\'t work out from the documentation or the examples if SSIS is suitable for my problem.
I have an ID in a package variable that I need to add as a column (with each row having that package variablevalue) in a Dataflow.
How do you access a Rec开发者_如何转开发ordSet variable inside a Script Task?Listed below is the code I used to load a datatable in a C# script task from a recordset or resultset variable. \"User::tra
加载中,请稍侯......