Need Assistance with Dynamic Properties and FTP Task

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!

cdun2On Apr 4, 5:35 am, "cdun2" <ChrisDunnM...@.gmail.comwrote:

Quote:

Originally Posted by

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

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.

cdun2sql

Need a task that will zip a file prior to upload via FTP

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.id gues you need a 3rd party piece of software for this. we have used PKZip exe here. its a simple command line app, so you can easily call in in a script task and get it to do its thing. there could be an easier way though...|||

We have written a SSIS Task to do this for you. It works rather nicely.

-Jamie

|||

Excellent! Thanks. Will you be posting a link to it on your blog?

Cheers

|||

No I'm afraid not because it is Conchango's own intellectual property. I was more making the point that this can be done.

Don't fret however, Darren tells me that he has built his own so look for it appearing on SQLIS.com soon enough.

-Jamie

|||Cool, thanks. I'll be looking for it to make its debut there.|||Is there an eta for this?|||I haven't found a task for this on sqlis.com or anywhere else yet, have you?|||

Al C. wrote:

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68|||

Or use this: http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

-Jamie

|||Thanks. It looks like that task compresses into gzip format. I need the same format as when you do a right-click > 'Send to compressed (zipped) folder' via Windows since we send the file to clients who expect that format.|||

Duane Douglas wrote:

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68

Thanks. I posted the suggestion.

|||

Hi

I am also looking for the same task, what solution have you adopted in answer of your problem?

|||We purchased WinZip product with command line interface. I added an Execute Process task to run the WinZip and I pass the file name in the command line arguments. There are other products that can do the same I believe, such as PKZip.|||We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/

Regards,
Ivan

Need a task that will zip a file prior to upload via FTP

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.id gues you need a 3rd party piece of software for this. we have used PKZip exe here. its a simple command line app, so you can easily call in in a script task and get it to do its thing. there could be an easier way though...|||

We have written a SSIS Task to do this for you. It works rather nicely.

-Jamie

|||

Excellent! Thanks. Will you be posting a link to it on your blog?

Cheers

|||

No I'm afraid not because it is Conchango's own intellectual property. I was more making the point that this can be done.

Don't fret however, Darren tells me that he has built his own so look for it appearing on SQLIS.com soon enough.

-Jamie

|||Cool, thanks. I'll be looking for it to make its debut there.|||Is there an eta for this?|||I haven't found a task for this on sqlis.com or anywhere else yet, have you?|||

Al C. wrote:

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68|||

Or use this: http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

-Jamie

|||Thanks. It looks like that task compresses into gzip format. I need the same format as when you do a right-click > 'Send to compressed (zipped) folder' via Windows since we send the file to clients who expect that format.|||

Duane Douglas wrote:

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68

Thanks. I posted the suggestion.

|||

Hi

I am also looking for the same task, what solution have you adopted in answer of your problem?

|||We purchased WinZip product with command line interface. I added an Execute Process task to run the WinZip and I pass the file name in the command line arguments. There are other products that can do the same I believe, such as PKZip.|||We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/

Regards,
Ivan

Need a task that will zip a file prior to upload via FTP

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.id gues you need a 3rd party piece of software for this. we have used PKZip exe here. its a simple command line app, so you can easily call in in a script task and get it to do its thing. there could be an easier way though...|||

We have written a SSIS Task to do this for you. It works rather nicely.

-Jamie

|||

Excellent! Thanks. Will you be posting a link to it on your blog?

Cheers

|||

No I'm afraid not because it is Conchango's own intellectual property. I was more making the point that this can be done.

Don't fret however, Darren tells me that he has built his own so look for it appearing on SQLIS.com soon enough.

-Jamie

|||Cool, thanks. I'll be looking for it to make its debut there.|||Is there an eta for this?|||I haven't found a task for this on sqlis.com or anywhere else yet, have you?|||

Al C. wrote:

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68|||

Or use this: http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

-Jamie

|||Thanks. It looks like that task compresses into gzip format. I need the same format as when you do a right-click > 'Send to compressed (zipped) folder' via Windows since we send the file to clients who expect that format.|||

Duane Douglas wrote:

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68

Thanks. I posted the suggestion.

|||

Hi

I am also looking for the same task, what solution have you adopted in answer of your problem?

|||We purchased WinZip product with command line interface. I added an Execute Process task to run the WinZip and I pass the file name in the command line arguments. There are other products that can do the same I believe, such as PKZip.|||We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/

Regards,
Ivan

Need a task that will zip a file prior to upload via FTP

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.id gues you need a 3rd party piece of software for this. we have used PKZip exe here. its a simple command line app, so you can easily call in in a script task and get it to do its thing. there could be an easier way though...|||

We have written a SSIS Task to do this for you. It works rather nicely.

-Jamie

|||

Excellent! Thanks. Will you be posting a link to it on your blog?

Cheers

|||

No I'm afraid not because it is Conchango's own intellectual property. I was more making the point that this can be done.

Don't fret however, Darren tells me that he has built his own so look for it appearing on SQLIS.com soon enough.

-Jamie

|||Cool, thanks. I'll be looking for it to make its debut there.|||Is there an eta for this?|||I haven't found a task for this on sqlis.com or anywhere else yet, have you?|||

Al C. wrote:

I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this? Thanks.

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68|||

Or use this: http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

-Jamie

|||Thanks. It looks like that task compresses into gzip format. I need the same format as when you do a right-click > 'Send to compressed (zipped) folder' via Windows since we send the file to clients who expect that format.|||

Duane Douglas wrote:

you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx?SiteID=68

Thanks. I posted the suggestion.

|||

Hi

I am also looking for the same task, what solution have you adopted in answer of your problem?

|||We purchased WinZip product with command line interface. I added an Execute Process task to run the WinZip and I pass the file name in the command line arguments. There are other products that can do the same I believe, such as PKZip.|||We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/

Regards,
Ivan