You could try something like this, create a global variable (g_PackageLog for example) and give it a value including the fully qualified path and then in an ActiveX script:

Function Main

DIM...

Try using an ActiveX script in DTS to create the Excel file and control the name of it there, including the date in the name.

I always try to set the connections for the packages to use (local) as the server instead of a server name (along with a trusted login). I can move packages...

If you visit this site http://www.sqldts.com/ they have a very handy tool called DTS Backup that has been working well for me. I use it to backup all DTS packages...

Scott,

You could try using an ActiveX script in the Transformations portion of the DDQ. Delete the existing transformations and select "New", "ActvieX Script" and then set your source and binding...

True, the datpump will be more efficient. The only advantages to my solution would be ensuring the file always exists where you expect it and you can now do some...

You can accomplish this using the Execute SQL task. First create a Global Variable in the DTS package. Now in the Execute SQL task add your query and go the...

Bob,

Yep - you have two choices at the precedence, delete and redo or copy from the step(s) name. I prefer the redo (it is easier!!)

You should be able to find examples of both at http://www.sqldts.com

If you have the option - VB.Net can use the FileSystemWatcher to monitor a directory for file activity. I have used this and it works just fine (you can watch...

I use the disconnected edit option but the catch is you need to change several properties per task and step. If I have mulitple processes/tasks in a package I perform...

Jason,

I haven't had the "opportunity" to test this workaround in a long time. A few years back I recall having a similar situation and I believe this was how I...

This link might be of help. http://www.sqldts.com/default.aspx?297