Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2014-09-10 : 11:44:05
|
| I have a variable i created to connect to my ftp site and retrieve files from a FTP site. path is ftp://NPR_EMPLOYEES_Account@08.25.0.45/employee/the name of the files are date stamped npr_Employees_01_21040801my variable is set to"\\"+"Employee"+"\\"+"npr_Employees"+"_01"+"_"+(DT_STR,4,1252) DatePart("yyyy",getdate())+ Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2)however it is erroring out Is this a bug withh SSIS 2012 is it because my variable beging with / Please advise |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-09 : 00:28:39
|
| 1. set value of veriable to /2.set required value to variable in script taskRegardsViggneshwar A |
 |
|
|
|
|
|
FTP TASK ERROR