November 20, 2009 at 8:29 am
Hi is there a way to programatically determine the execution value of SSIS FTP task attempt at transfering a file.
November 20, 2009 at 9:47 am
Can you please explain the scenario in detail?
[font="Comic Sans MS"]--
Sabya[/font]
November 20, 2009 at 9:57 am
I am using the FTP task editor to transfer files from several different location, and will like to enter a log in the database whenever a file is successfully transfered using the FTP task.
i assumed that within the SSIS package there exists a task variable that holds that information but cant seem to find anything like that.
November 20, 2009 at 5:59 pm
[font="Comic Sans MS"]You can have two execute sql tasks - one for success path and one for failure (from FTP task). These execute sql tasks will insert the required log into the required table.
If you are using a container - you can configure maxerror parameter so that pkg/container won't fail in case ftp component fails.
Let me know if this works for you.
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply