March 16, 2009 at 6:30 am
hi
my trigger is simple i don't know why it by pass when i m importing data through using sql server import and export wizard... if i am executing one by one insert statment then it's work perfectly but through import and export wizard trigger not fire that time ...
my trigger script as below pls help me if anybody know abt this
create TRIGGER [dbo].[Tr_insert]
ON [dbo].[table_raj]
AFTER INSERT
as
begin
select * from inserted
end
Raj Acharya
March 16, 2009 at 8:04 am
is there any one who has idea related to this
Raj Acharya
March 16, 2009 at 11:55 pm
What are you trying to do Raj? See what is in the Inserted table in for the trigger?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 12:23 am
i m not seeing that inserted data i know that i can see through directly this is for just example...what i m doing is from from inserted data i m doing some calculation into that and put that into another table all this process i m doing into trigger...what my mean is trigger is bypass ....can u understand what i m trying to say
Raj Acharya
March 17, 2009 at 6:15 am
Hi,
pls check in your ssis if you have selected data access mode to 'Table or view -fast load' then switch to 'table or view'.
I had the same problem on some of my imports.
Regards,
René
March 17, 2009 at 6:32 am
can u pls tell me how can i check this ...
Raj Acharya
March 17, 2009 at 6:40 am
Hi,
after the ssis-package is created, open the 'data flow task' for edit and select the destination object and open it for edit. In the middle you'll find data access mode, change here to 'table or view'. Save and start your package.
Regards,
René
March 17, 2009 at 6:57 am
hi thanx for fast reply....
i have done changes and set that it to table or view... still same thing happening it's bypassing trigger
Raj Acharya
March 17, 2009 at 7:30 am
hi rene thank you very much man....you are great...
i have done that change and what i have seen this is working....
but i have one question when we are doing import and export wizard is that time we can set this thing...bec as per you told we need to save package and then edit and then we have to do this....but can't we do this directly
Raj Acharya
March 17, 2009 at 8:58 am
Yes, you have to save the package first and edit later on.
Regards,
René
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply