Cheryl on the Web

Disclaimer: If you are not familiar with the SQL Server 2005 equivalent of SQL Server 2000 packages - SSIS packages - then you need not read further.

For the rest of you: beware of the limitations you will face when using the Execute Integration Services Package task in SSIS workflow for SQL Server 2005. Under other circumstances, when running such a package as a job or manually, you can pass in configuration settings using XML configuration files or using command line parameters. Unfortunately, when running a package as a nested (”child”) package using this SSIS package task, you can’t pass in any configuration options (more…)