SSIS - How To Create This Package
-
This should be fairly simple, but I'm rather new to SSIS. I want to copy data from one table to another. The column names are not the same, and in the target table I may need to expand some columns so I don't get truncation errors. I'm not really sure what objects in SSIS to use. Many thanks
Everything makes sense in someone's mind
-
This should be fairly simple, but I'm rather new to SSIS. I want to copy data from one table to another. The column names are not the same, and in the target table I may need to expand some columns so I don't get truncation errors. I'm not really sure what objects in SSIS to use. Many thanks
Everything makes sense in someone's mind
If the copy operation is quite simple, try following:
- define a Data Flow task and open it
- using Source Assistant, define the source database
- using Destination Assistant, define the destination database
- configure the source table for OLE DB Source (double click it to open the confiiguration)
- do the same for OLE DB Destination
- if you need expressions, add a Derived Column
- configure the derived column; add necessary new derived columns, their expressions etc
- connect the source to the derived column
- connect the derived column to destination
- in OLE DB Destination configure the mappings
Hope this gets you started :)
The need to optimize rises from a bad design.My articles[^]
-
This should be fairly simple, but I'm rather new to SSIS. I want to copy data from one table to another. The column names are not the same, and in the target table I may need to expand some columns so I don't get truncation errors. I'm not really sure what objects in SSIS to use. Many thanks
Everything makes sense in someone's mind
Follow the series of the video tutorials.. http://www.youtube.com/watch?v=tPdUYpi-m10[^] hope it helps.