Moving to SSIS for package execution was my first thought as well when I realized that we needed to execute in parallel. I also used the execute task to execute...

ah, found this nifty link in relation to the dynamic connections in SSIS

http://qa.sqlservercentral.com/articles/Video/64262/

Just curious, does anyone use the SQL table for storing their configurations?

well, it was basically telling me that the meta data was out of sync. I only needed to open the package and close it, and the error was resolved. We...

1. Could you please post type of packages you are running?

I'm not exactly sure what you mean by type of packages. Most of the Constructs in SSIS are being used...

Something to keep in mind as well is that SQL2008 and the corresponding release of SSIS now has the ability to use C# as script component. So you don't necessarily...

You can set up a SQL Server Agent job to execute the Sproc at defined intervals.

Hey khaysmer,

It Looks like you may be missing the insert statement before your select.

typically it would look something like

Insert into Yourtable (value1, value2, value3)

SELECT ...