Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File Archive Question in SSIS Expand / Collapse
Author
Message
Posted Monday, October 14, 2013 3:27 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 232, Visits: 905
Hi guys,

Here is my question, I have to archive every day file. I know I can use
File System Task to transfer file from one folder to other. Here is the problem
File Name always different, here is the e.g (FileName_getdate), so filename
always gonna same_Date when package runs. Is anyone can guide me...

Thanks in advance.
Post #1504558
Posted Tuesday, October 15, 2013 12:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:20 AM
Points: 5,180, Visits: 12,033
If you've processed a file with a dynamic name, you must already have the file name in a variable. Use that in the FST.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1504613
Posted Tuesday, October 15, 2013 12:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
As Phil has already answered, there is an option called as "IsSourceConnectionVariable", set this as true and assign the variable name as the one holding the file name.

Here is a good resource:

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1504616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse