December 5, 2006 at 4:56 am
hello !!
If i wana to find bad records from my DTS package having bulk insert (select * into or insert into table_name) statement ..how should i get that bad records..
Also can u get for some good articles link for TRIGGERS in sql server 2000
T.I.A
Regards,
Papillon
December 5, 2006 at 8:21 am
Just what exactly do you know you have bad records?
December 5, 2006 at 9:13 am
Designate an exception file for the Transform Data task on the 'options' tab of the task properties. Uncheck '7.0 format' and check 'Error text', 'Source error rows', and 'Dest error rows'.
You can also designate a package error file on the 'Logging' tab of the package properties.
Greg
Greg
December 6, 2006 at 9:40 am
Bulk Insert task does not provide much flexibility. If you want to conditionally insert you may want to use Transform Data Task
December 6, 2006 at 4:59 pm
you're right about the Bulk Insert task but I don't think he's using one since he has a SELECT query in it. It appears that he's importing from a table.
Greg
Greg
December 6, 2006 at 9:19 pm
yes i m imoprting from table so if there is any duplicate records then it may fail....
Regards,
Papillon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply