May 3, 2004 at 1:40 pm
Hi guys,
We had a strange problem (may be not after going though some of the post here). This morning when I came in one of our DBA's wanted to import data from a tab delimited text file into a table (Table1) in SQL. Table1 has associated trigger on Insert & Update. He used import data wizard to copy the data from text file into Table1.
After completion the data was imported into Table1 just fine, but the trigger did not fire when the records were inserted. So I made a search and read about "use fast load", and unchecking it in DTS allows the trigger to fire (because now its inserting row by row).
But, I was wondering if there is a way to uncheck "use fast load" while using the import wizard? Or is there any other way to fire the trigger while using the import wizard rather than creating a DTS and then re-doing the whole process with out "use fast load"
thank you all in advance,
V
May 4, 2004 at 4:44 am
Unfortunately currently the Import/Export Wizard does not expose the options to do what you are asking. However in SQL 2000 bcp does have a FIRE_TRIGGERS hint you can use. But otherwise you will need to create a DTS package to expose the option, make generic enough where you can change it for use on all text imports.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply