Groups | Blog | Home
all groups > sql server dts > april 2007 >

sql server dts : Need Assistance with Dynamic Properties and FTP Task


cdun2
4/4/2007 3:32:01 AM
Hello,

I am building a packge where an FTP task needs to pull down a single file
every day from a specific location. The location will only have the one file.
The file name will be different every day. A sample of one of the file names
looks like this:

CDNSC.CDNSC.SC00015.04012007

The file names will be different every day, as the last eight digits
represent the date of the data in the file. The source files will be located
in a subdirectory called 'outgoing'.

My first approach to this has been to use a Dyamic Properties Task to set
the SourceFileName of the FTP Task. I tried using a sting Global Variable
expressed as *.*.*.* thinking a wildcard would work, but it didn't.

What approaches can I take so that the Source Filename in the FTP task will
dymanically update each day to get the one file?

Thank you for your help!

cdun2
cdun2
4/4/2007 12:28:04 PM
I wound up creating a script solution that was pretty straight forward. I
basically set up string variables using DATE to get the data portion of the
file name, concatenated that to the first part of the filename, and set the
whole string equal to the SourceFileName of the FTP Task. It seems to work
fine.

cdun2


[quoted text, click to view]
AddThis Social Bookmark Button