Auto Generate large amounts of Target DDL only with SSIS
Hi, I'm working on a archiving project where I need to archive large amounts of iSeries(DB2) tables(running into many thousands) into SQL Server using SSIS. I have two problems: 1. The target tables are not present in the SQL Server 2. I've created schemas for certain objects and they need to be created on the aforementioned schemas. I'm currently looking at ways to automate this by first generating the DDL alone. Request help and guidance on this.
September 30th, 2012 8:39am

One way to do this is to query the DB2 schema using the ANSI-standard INFORMATION_SCHEMA views. Convert the column definitions to the SQL Server counterparts in a Script Task to generate the needed CREATE TABLE statements and execute. Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2012 9:30am

Create a DB2 linked server (Follow this) and then use SSIS transfer sql server objects. Alternatively follow this to download connectors for DB2 from SSIS and then try using transfer sql server objects.http://btsbee.wordpress.com/
September 30th, 2012 7:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics