all groups > sql server dts > november 2006 >
You're in the

sql server dts

group:

DTS Package Fails


DTS Package Fails qjlee
11/28/2006 8:31:02 AM
sql server dts: Hi, I have a dts package which contains serveral steps and recently it has
been failing in one of the steps. Is there any way I can trace why it fails?

RE: DTS Package Fails qjlee
11/28/2006 11:31:02 AM
Can you tell me how to enable the dts logging?

Thanks,

[quoted text, click to view]
Re: DTS Package Fails Allan Mitchell
11/28/2006 7:20:08 PM
Hello qjlee,

Enable logging in the package. If you are executing the package interactively
double clicking on the error in the window after failure should give you
an idea of why the package has failed.



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]

RE: DTS Package Fails Allan Mitchell
11/28/2006 9:24:08 PM
Hello qjlee,

On the designer surface right click. You should get a context menu.

Select Package Properties
Now look at the Logging tab


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button