Using a Dynamic Filename in SQL Server 2000 DTS FTP Task

I am trying to write a SQL Server 2000 DTS package that will pull down a file using SQL Server's "FTP TASK". The catch is... the file that I am trying to pull down has a filename that is based on the date that the file was created. For example: the filename is '03012007.ZIP' on March 1st, 2007. On March 2nd, 2007, the filename will be: '03022007.ZIP', etc... I will need to write a VB Script that will dynamically create the name each day.

Question is:
What would I do to my DTS 'FTP Task' so that I can pass it the dynamic filename each day?
*I ask that you please be as specific as possible in your responses since I am so new with DTS.


ccptechsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rboyd56Commented:
I do not know if this will help. It is basically the reverse of what you are trying to do but you might be able to get some pointers that will help you:

Using DTS and FTP to Push Files
http://www.sqlteam.com/item.asp?ItemID=12408
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nmcdermaidCommented:
This might help you:

http://www.sqldts.com/302.aspx


The other way is to write an ActiveX script that works out the filename then pushses that in against the FTP source file property.

... but try the link first.


You will find that site is very helpful.
0
ccptechsAuthor Commented:
Hi Guys -

Thanks for your responses, but it does not solve my problem. I don't want to 'go around' the standard FTP Task in DTS. I want to use it with a dynamic filename.
0
ccptechsAuthor Commented:
I appreciate the help, but none solved my issue. I will try again...
0
nmcdermaidCommented:
Then you need to write some activeX to fill in the properties of the FTP task.

Click on a blank part of the DTS. Right click/disconnected edit.

You can browse through the tree till you find the source filename property of the FTP task.

This can be set programattically within an ActiveX task.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.