June 20, 2013 at 1:25 am
Hi All,
I have one scenario I create one package in which file is coming at daily basis and data is load in table but in case bad data will come and it fails to load data in table in that case file should be move at error archive folder and that source location will be free for next file. it get copy but i want to move file permanently at error archive folder when package get failed .
So please anybody look into this..
Thanks in Advance..
June 20, 2013 at 2:23 am
Hi,
If you're already copying the file then can't you just change the file system task to complete a "Move File" operarion rather than a "Copy File" one?
Or have i mis-understood your problem?
Thanks,
Simon
June 20, 2013 at 2:50 am
actually it hold the file so moving file is not possible but copying is done but we have to move it.
June 20, 2013 at 2:55 am
Is the file system task in an event handler, or is it a separate task on the control flow?
Thanks,
Simon
June 20, 2013 at 3:26 am
it is a separate task on control flow...
June 20, 2013 at 3:28 am
OK so try doing a "Move File" file system task in an OnError event handler on the data flow.
Thanks,
Simon
June 21, 2013 at 5:48 am
Could you please elaborate the steps what you have try to saying.
June 21, 2013 at 6:31 am
Hi,
So i've included a screenshot....
There should be an event handlers tab when you open the package. On there you can select an event handler for a particular executable, or the entire package. Select you data flow in the executable drop down, then all you have to do is create a "Move File" file system task.
Hope that helps a bit more.
Thanks,
Simon
June 21, 2013 at 8:21 am
Its working now ..
Thanks:-)
June 21, 2013 at 10:18 am
Great!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply