September 7, 2008 at 9:53 pm
if i have a file in a directory and i need to get the file name in a variable (package variable in ssis) and then i want to change the file name in the directory.
For example.
if i have a flat file in a directory and the name of the file is sample.txt
i should get me the file name in the ssis package variable and then i need to change the file name to sample_ssis.txt after processing the file. How to write the code for this. Its urget
anybody help appreciated
murali
September 8, 2008 at 8:09 am
I'm assuming you already know how to get the file name into a variable and how to process it.
After processing the file use a File System Task with an operation of Rename File.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 8, 2008 at 10:34 am
Hi Jack,
i am new to ssis.i have no idea about to get filename into variable and how to process it.
how to use file system task to rename file tell me detail steps
thanks for help
murali
September 8, 2008 at 12:23 pm
if ur not familar with file system task, how about using execute sql task and use xp_cmdshell to get a directory listing and rename the file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply