Moving and Renaming files in SSIS

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Moving and Renaming files in SSIS

Moving and Renaming files in SSIS

Topic RSS Feed

Posts under the topic: Moving and Renaming files in SSIS

Posted: 1/11/2012

Padawan 244  points  Padawan
  • Joined on: 6/14/2010
  • Posts: 87

Hi forum,

I have Package that creates 2 txt files(a20120111.txt  and b20120111.txt) in 2 different folders , Folder A and Folder B. I need to rename the file a20120111.txt to c20120111.txt to and move to another folder Folder C. i have followed 

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

but it does not work work .. anyone please...


Posted: 1/11/2012

Jedi Knight 1516  points  Jedi Knight
  • Joined on: 1/3/2010
  • Posts: 266

Hi jampa.

Well, there are a lot of solutions to do what you need need. Another approach is by script task as shown by Nayan.

You link us to a solution. Instead of that, can you show us what kind of problems are you facing, or erros, so we can debug your problem and try to help you?


Posted: 1/11/2012

Jedi Master 3057  points  Jedi Master
  • Joined on: 2/19/2010
  • Posts: 449

I have an ETL process that uses this exact method, I believe I even read the same blog.  You are going to have to elaborate on the problems you are having.


Posted: 1/11/2012

Padawan 244  points  Padawan
  • Joined on: 6/14/2010
  • Posts: 87

Marco,

[File System Task] Error: An error occurred with the following error message: "Could not find file '\WorkingFolder\Restaurant Master20120110.csv'.".

this is the error i got when i tried to get 


Posted: 1/11/2012

Padawan 244  points  Padawan
  • Joined on: 6/14/2010
  • Posts: 87

Hi Daniel,

I used 2 queries in 2 DFT to extract the results into 2 .csv files 

fileA20120111.csv and fileB20120111.csv these to file are placed in 2 different folders

FolderA holding ---fileA20120111.csv

FolderB holding ---fileB20120111.csv

this part im done .

the final step is FolderC which should hold fileA20120111.csv with a different name filenewname20120111.csv

i tried the example from Rafael but the error i got was file not found. Can you give me the steps to modify example to suit my task

[File System Task] Error: An error occurred with the following error message: "Could not find file '\WorkingFolder\Restaurant Master20120110.csv'.".

 

thank you


Posted: 1/11/2012

Jedi Knight 1516  points  Jedi Knight
  • Joined on: 1/3/2010
  • Posts: 266

that looks like the path is malformed. Can you start by checking the path produced? maybe with a script component using msgbox to see what is the variable value.

Make sure your file "Restaurant Master20120110.csv" exists in the desired path and it has space in the middle.


Posted: 1/12/2012

Jedi Knight 1644  points  Jedi Knight
  • Joined on: 3/24/2010
  • Posts: 218
Answered  Answered
Page 1 of 1 (7 items)