Rename a File in SSIS (SSDT) using an expression

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I tried the following but I got an error?

Substring( @[User::MyFileValue] ,1,3)

The variable User::MyFileValue was not found in the variables collection. The variable may not exist in the correct scope.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I used the following example to rename the file from abc.txt to abc-72015.tx:.

[/

url]

I need to do the reverse:

abc-72015.txt to abc.txt

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 3

Quick thought, you can either do a copy/rename snd a delete with a file system task or a rename with a scipt task an file system objecr.

😎

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I am using a File System Task.

The Package is located at the following URL

[/

url]

I want to rename import20150723.txt to import.txt

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/