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 : 12:16:09
|
| 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 / |
|
|
|
|
|
FTP TASK