March 18, 2011 at 5:26 am
I created on ssis package which contain one for each container.In this for each container i have one script task which download file from ftp to local machine and one data flow task which import data from this excel file to sql server.
If excel file format right then package executed succesfully but if user put wrong excel file format then package going to be failed and after that remaining file also not processed.
I tried to create event handler on error for each container but it still going to be fail.And this event handler fired three times.
How i can handle these format issue in ssis using event handler?
Thanks
Kapil
March 18, 2011 at 7:54 am
What I would do in that situation is create a failure path. You can add another step and when you connect it click on the connecting path arrow. You can then change that to a failure path. So when the first step fails to find the file you could for example tell it to send you an email or rename the file to the correct name. what ever the appropriate response should be.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply