Thank this author by sharing:
By Brian Knight,
A major consideration we must review is the datatypes of your DB2 data. You will need
to check the datatypes on DB2 and SQL Server to make sure that they will
support each other. The chart below covers covers the supportibilty of the datatypes (see books online for more information).
Importing CSV file from remote server using SQL Server package.
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transfor...
DTS package import
Import Transformation VB Script
How to switch datasources once SSIS package is imported to different server