SSIS 2005

SSIS Import from Multiple Databases

How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

Why is SSIS xml variable in escaped format?

In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...

.dts and .dtsx config files in SQL Server 2005

Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

SQL Export to Excel file column?

I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

iSeries to SQL Server via SSIS 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.