March 21, 2012 at 3:53 pm
I am trying to use FTP task to send files across. When I give the LocalPath is variable as True and in the expressions pane, LocalPAth create an expression that dynamically (Date time is dynamic)evaluates to the file name, it fails. After some research tried using foreach loop and pass the the variable to the FTP but was unsuccessful.
Used the link below to get the dynamic file name
http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
Passed in the variable created to the FTP task and its failing. Unable to connect to FTPConnectionManager. I was able to run this with a static file name.
Any help would be greatly appreciated.
March 22, 2012 at 9:27 am
Resolved this.
Set the variable path wrong. Use message boxes to view variable values at run time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply