Solved

SSIS File System Task

Posted on 2011-09-26
3
428 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 50 total points
ID: 36598990
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 200 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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