Thanks, Andy, for taking the time to put this article together. Sure was great to get a hands-on demo from you yesterday... then seeing the article today. How timely 😉

This...

Employees that know the SA password?!? Eek! That's a good Halloween story.

 My take from reading the original post is that there would be some sort of security model in place...

Now THAT's a genius idea!  Who's going to be the first to write this program up??

It would help if the code was more readable

 It appears that the condition that is causing the problem is when the file is not...

Unfortunately, you cannot pass a global variable to an Execute Process task (in the Parameters field in EM). It is possible to update an Execute Process task's parameters field, but...

Have you tried digitally signing the macro in the Excel file?

Otherwise, you can try using sendkeys to click the button.

How are you attempting to access this information? C+? VB? Internally to the package?

If you are attempting to retrieve information about the source columns for a transform within a DTS package...

Very interesting scenario. The way I would go about the issue is by creating a new ActiveX script task and first check each csv for column counts. If the csv...

Will you please provide more information as to how your DTS package is designed? How are you looping through the files? Are you changing the data source for the transform...

In my experience, I've found that the "synch" issue normally occurs if there are two or more instances of the same connection (like referencing the same Excel file for two...

Never heard of it. But I managed to find this page:

http://www.pcrei.com/ppro/files/index.html

There are a couple of things that I can think of that may be causing this to happen:

(Most unlikely) - Too many versions of the DTS package. I normally keep...

You'll need to output the results of the Execute SQL into a recordset global variable. Then you can use VBS to extract the data from ther recordset (which is what...

Apparently, you are not a person who works in Information Technology and according to you're own post, you do not know.

Being part of IT in a fairly large healthcare provider, we are currently in a position where we are investigating the pros/cons of implementing a BI product. I'm a "lower-level"...