It is the connection manager used by the SQL statement in the script task that determines whether the SQL statement can be executed.

If your connection manager is using authentication...

Sounds to me like it is not finding the data files. Make sure you have the paths set correctly, and files actually in the folders.

That's what this job actually does. I just used local directories for demonstration purposes.

You would simply change the directory path from c:\folder\ to \\server\folder\, if I understand your question correctly.

You could create a separate script task that would count the files in the various subdirectories using an array list containing the subdirectories you want to search along with the...

Indexes will definitely help.

The only way to know for sure is try it both ways.

From my experience, a temporary table is the only way to go with that many records.

A table variable or CTE would be way too slow.

All you have to do is change "put" to "get."

You're path has to be pointing to a file that actually exists on the remote server, but that's about it.

Why don't you do like I did, Bill and write an article and share your knowledge?

Or do you simply prefer telling other people how stupid they are?

Besides which, tell me...

My guess is that it is choking on the elapsed time calculation.

Try commenting out that entire section ('Calculate execution elapsed time..., except for the Dim statement that creates the elapsed...

Sorry, but the answer is you can't get the time stamp of a processed data file from an event handler.

I was just trying to show you why I resorted to...

Is there an event handler to get the time stamp of a source data file being extracted by an SSIS package?

You could make a template of this package, too, and build all your SSIS packages by adding components to the sequence container.

There are always a million ways to do anything....

I tried to post this to you the first time, but it went to Grasshopper, I think. I am going to try again.

I finally got a chance to write some...

I finally got a chance to write some code. I had to change the global variable "SourceFilePath" to "SourceDirectory." You can download a revised version of the SSIS package here:...

Doesn't work with wild cards. You're not in DOS, your using VB.NET SYSTEM.IO objects.

I went through all this myself. There is no other way.