Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS File System Task

Posted on 2011-09-26
3
Medium Priority
?
435 Views
Last Modified: 2012-06-21
Has anyone got any good examples.
I have a xls file that i am populating, i then need to copy the file to a new dir and rename the file with a date.
0
Comment
Question by:aneilg
3 Comments
 
LVL 17

Assisted Solution

by:OriNetworks
OriNetworks earned 200 total points
ID: 36598990
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 800 total points
ID: 36707730
Yes,

If you are loading the file first in database then you have name and path of the file.
Give the path and file name to move using expression.

"\\\\" +  @[User::FILE_SHARE] + TRIM(@[User::Done]) + LTRIM(@[User::FileName]) + (DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) +  RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2) +   ".txt"
0
 

Author Comment

by:aneilg
ID: 36709759
i've created a variable 'Rename_my_Extract' string. vale \\server-001\Data\patn\my Extract.xls

i then create a New File connection point it to the xls. If i then go into the expressions tab and create the expression. evaluate its fine. bu ti get an error when i test the file system task.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question