Your joins between text files are doubtful in my opinion unless they are a form of XML such as XSD (even then, it would be a stretch for DTS).  I...

Take a look at this article:

http://www.aspfaq.com/show.asp?id=2445

-Mike Gercevich

DTS is not SQL.  It is COM+ objects that have methods and properties that are accessible from applications that can call COM.

You can export the code of a DTS package...

Thought i'd throw this out there for you to test out... in your lookup query, try adding a " WITH (NOLOCK)" on your FROM clause... this will keep it from...

I think you should look into using a third party FTP component that you can instanciate from an active-X script and manage your download via programmed logic.  The FTP Task...

One thing to watch out for when purchasing a product from a third party...

If the package can be used to validate to USPS CASS certification standards, the data will...

I believe this article may be what you are looking for...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_46xv.asp

-Mike Gercevich

Add an active-X script to change the ExceptionFileName property of your Data Pump Task Object before it is executed.  Remember to include the full path to the filename.

-Mike Gercevich

You would be far better off saving your variables to a table and have your package read them in at the first step of execution.  If you call the Package...

If you are talking about the Package Password...not connection passwords... You cannot change that password via disconnected edit.  Use the "Save As..." function in the menu.

-Mike Gercevich

SQL Server Magazine did a comparisopn showdown a few years ago... the article can be found here:

http://www.windowsitpro.com/SQLServer/Articles/ArticleID/19760/pg/2/2.html

-Mike Gercevich

Have you looked at bcp.exe with the -c -t options?  This should execute the fastest of all the different ways of doing this task.

-Mike Gercevich

If you are frequently having to perform this task, you may want to look into a utility designed specifically for this task.  I can speak for Red-Gate's SQL Compare as...

The last word I have heard is that Microsoft will support the current and last versions of server products.  SQL 7 will most likely be dropped soon after SQL 2005...