hi all,
please help,
i using Execute DTS 2000 Package Task to create a package.dtsx, and execute successful in VS2005
but when i created it as a job and it fail to run.
the package.dtsx is calling a package2000.dts, which having 2 steps to run.
i execute the job by step, and the i found that the 1st job is running successful but the 2nd job was fail.
may i know where can i found the error log? or any where to debug it?
please help......
thanks 1st.....
Hi Khin,
* Note that configuring log for SSIS will not provide the log for Individual steps run in the Execute DTS 2000 Package task.
* Configure a Separate log for the DTS file enclosed by opening it in DTS designer, right click -> Properties ->Logging -> <Give a file Path to Store this log file >.
Thanks
Subhash Subramanyam
No comments:
Post a Comment