I need to pick an excel file from some other server and bring it to some other server....through script task in SSIS
Hi All, I need to pick an excel file from some other server and bring it to some other server....through script task in SSIS.... Please help....
January 26th, 2011 7:08am

Save the path of two different server along with folder name to two diff variable. you can pass it through config file also. Pass this two variables to script task readonly variable list.inside script task use System.IO name space, then use File.Copy methodChandrajit Samanta
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2011 8:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics