All,
After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to complete. How can I get this to complete without having to go into the DTS package and then maunally intervene?
Thanks,
Gabriel Boyer
Software/Hardware used:
ASKED:
January 9, 2008 5:11 PM
UPDATED:
January 10, 2008 2:34 AM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.