All you are really doing is changing the connection string on each of the packages and the packages are executed from SQL Agent? If so, you can change the...

You could build a VB or C# app to open the packages one-by-one and examine the connections collection. I *think* you can read them directly from the server but...

If you think the GUI is painful. Wait for the pain that directly editing the DTSX file brings. It gets easier.. I promise. The first several...

Could you send screen shot of your package, I for the life of me can't visualize what you are telling me..

CEWII

You might try setting the max error value in the F-E-L to a number higher than 1, try 5000..

CEWII

Super.

CEWII

What is InventoryUpdateWGC?

It seems that that component wants to use both ADONET_KALAC_1 and OLEDB_INVENTORY_1 but neither is found.

After you explain what that one component is we might make...

You can do the install from the SQL Server disk. If you have VS 2008 already installed you will need to apply VS SP 1 first or it won't...

Add a script task to the control flow and look to see if the file is there. If not then send an email. Those are the broad strokes..

CEWII

On guard!

CEWII

And George, I shall continue to spar you for point counts.. 😛 I'm trying to get my overall rank under 60 this week..

CEWII

I was looking at it a bit ago and age is the only option. I guess I would ask why that is a problem? Disk is cheap, don't...

You can filter what is set, it is little more than a WHERE clause. As far as SSIS (NOT DTS) you might even be able to use the query...

I was looking at this in SQL 2008 and it does give you the options. Not sure if there is a difference. I haven't set up LS in...

There is an outstanding Microsoft Connect (connect.microsoft.com) item requesting that this kind of information be available. Short of coding something that keeps track of its own call stack there...