iSeries to SQL Server via SSIS 2005
Home > IT Answers > SQL Server > iSeries to SQL Server via SSIS 2005
Oldmickey
15 pts.
0
Q:
iSeries to SQL Server via SSIS 2005
SSIS Package 2005, iSeries Data Source, SQL Server, SSIS 2005, SSIS
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.
ASKED: Mar 5 2009  4:56 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Mar 6 2009  1:18 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0