Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS error handling

Author  Topic 

thanksfor help
Posting Yak Master

106 Posts

Posted - 2005-07-21 : 17:37:43
Hi,
I am new to DTS wizard.
Is there a way to set error count in DTS wizard.

Thanks.

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2005-07-21 : 18:01:48
You can't set in the wizard AFAIK. But all you need to do is save the package on the server then go back and edit it in the DTS designer.
Go to Top of Page

thanksfor help
Posting Yak Master

106 Posts

Posted - 2005-07-21 : 19:55:28
Thank U for tip. It did work.
Can I use select statement on the source flat file.
Because I am getting column delimiter not found error after 200000 records. If I can DTS first 200000 records then it will usefull to analysis the data for each field.
Go to Top of Page
   

- Advertisement -