Ok, I am about 99% sure this is your issue. SSIS has a problem when sprocs are used as the query source, I have not seem any really good...

You CAN edit DTS in-place but you cannot schedule them like you used to be able to do by right-clicking and chosing schedule..

I strongly recommend using source control for both...

Instead of environment variables I like to chose a location on the file system that I use on each server. Then the packages all point to the same place....

Editing the packages is always done with the files in BIDS. You cannot edit them "in-place".

From a source control perspective this is good. You should have a master...

In 2005 VB

In 2008 VB, C#

You could build an assembly in any language and call it from those languages. You do you have to add it to the GAC...

I'm not aware of a way to do this within the task itself. But you could trace it with profiler.

CEWII

It wouldn't be the Task Scheduler service that needs a restart, it woud be SQL Server Agent..

CEWII

Funny, thats what I was going to suggest when you responded.. Hate it when that happens..

CEWII

Caching comes to mind but the other thing that came to mind was did you set the SERVER variables and not the individual versions..

CEWII

I think you want to look at TransactionOption property..

From BOL:

NotSupported:

Specifies that no transaction will be started for this container, and consequently, the outcome of the current transaction, if one has...

First, I have never used this provider so I admit up-front I am grasping..

No parameters or expressions.. Ok, Does it have an option to accept the query command from...

Since this was posted in an SSIS forum I am assuming you want to do this in SSIS..

The built-in data sources CANNOT easily do this, you might be able to...

I realize re-install SSIS is NOT an ideal suggestion, unfortunately it is the only one I've seen solve this problem.

I did think of another couple of questions for...

I just looked at that, it looks like a nice framework, however internally it still uses sys.fn_get_audit_file..

CEWII

Super, glad to hear it.

CEWII