Building SSIS Package with Xtract IS Table Programmatically

In this blog I will show, how to create an SSIS package with Xtract IS Table programmatically. Our Package will extract data from an SAP table and load it to the sql server.

This scenario is very helpful to create your own packages, that you can load and reconfigure for different projects and customers.

In this sample we will:

• create a Package
• add a data flow task
• add connection managers
• add an Xtract IS Table source component
• add an OLE DB destination component
• connect data flow components and map columns

to read more, please refer to: http://www.theobald-software.com/blog/?p=316

Performing lookups by joining sap data with reference dataset in SSIS

In an SAP table many fields can belong to the table key. In some scenarios when you extract an SAP table with Xtract IS to load it into an SQL table, you want to replace the sap key fields by another custom key, e.g. a GUID.

read more on: http://www.theobald-software.com/blog/?p=247