You'll also find documentation in BOL, at http://msdn.microsoft.com/en-us/library/dn133186.aspx

There is also an MSDN article on generating reports in large volumes, using SQL SSIS and SSRS 2008 R2 -- http://msdn.microsoft.com/en-us/library/ff793463(SQL.105).aspx

I revised the script to compile successfully for the SSIS 2008 Script Task. Below is the revised code. Because the ActiveX Script is discontinued in the SQL Server...

I think the above example for Foreach Loop based on a variable would work for your package. You'd need to replace the ActiveX Script ("Begin Loop") with a Script...

What error message are you getting when you run the package? And, why does the Execute SQL Task need to run inside a Foreach Loop container -- For example, are...

I created a simple 2012 SSIS package with an Excel Source, Data Conversion, and OLE DB Destination components. The package ran successfully; the SQL Server table contains a "Copy...

The Data Flow task contains the Flat File destination and the destination component is generating the error, is this correct? What is the source component in the Data Flow...

For more information about events logged by SSIS packages the Integration Services Service, see these BOL topics, Understanding Events Logged by an Integration Services Package, Understanding Events Logged by the...

There are a few tips on this forum post, from someone who installed 2005 and 2008 on the same machine.

http://serverfault.com/questions/58194/running-sql-server-2005-and-2008-on-same-machine

SSIS 2008 can coexist side-by-side with both SSIS 2005 and SSIS 2000. For more information about compatibility issues, see "Interoperability and Coexistence" at http://msdn.microsoft.com/en-us/library/bb522577.aspx .

You can use an expression on the Excel Connection Manager ExcelFilePath property, to control the file name. You can then write to a different file on each loop iteration.

Have you confirmed that the Object variable contains data when the Foreach Loop runs? I can reproduce the same error when the Object variable is empty.

Also, what source component are...

SSIS Denali includes a new Left function. See this BOL topic for more information.

http://msdn.microsoft.com/en-us/library/hh231081(SQL.110).aspx

You may find this post on the SSIS forum helpful.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8deb1dd2-9c94-4514-9913-b217cd1e86fa

This SSIS BOL topic also provides info on installing an assembly in the GAC, as well as signing, building, and deploying an assembly.

"Building, Deploying, and Debugging Custom Objects" at