Home > IT Answers > AS/400 > iSeries to SQL Server via SSIS 2005
Oldmickey
65 pts.
 iSeries to SQL Server via SSIS 2005
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005
We have multiple DB2 Schema's that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.

Software/Hardware used:
ASKED: March 5, 2009  4:56 PM
UPDATED: March 6, 2009  1:18 AM
RELATED QUESTIONS
Answer Wiki:
You can use a script task with SSIS to change the connection string values as well as the values of other objects within the package.
Last Wiki Answer Submitted:  March 6, 2009  1:18 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _