Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SSIS OLEDB Destination Options Expand / Collapse
Author
Message
Posted Wednesday, January 18, 2012 10:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 6,146, Visits: 7,198
Comments posted to this topic are about the item SSIS OLEDB Destination Options


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1238436
Posted Wednesday, January 18, 2012 10:18 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 19, 2012 5:19 AM
Points: 72, Visits: 12
Trigger always fire when SSIS load or insert in SQl Server Database label or table base trigger

more.....

http://blog.sqlauthority.com/2009/05/27/sql-server-interesting-observation-of-logon-trigger-on-all-servers/


S/W Tofan Nayak
Post #1238437
Posted Thursday, January 19, 2012 12:04 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:29 PM
Points: 21,209, Visits: 14,901
I learned something new today - again.

Yay.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1238456
Posted Thursday, January 19, 2012 12:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 6,146, Visits: 7,198
tofan.nayak (1/18/2012)
Trigger always fire when SSIS load or insert in SQl Server Database label or table base trigger

more.....

http://blog.sqlauthority.com/2009/05/27/sql-server-interesting-observation-of-logon-trigger-on-all-servers/


That's for logon triggers. Setup a table trigger and try for yourself with an insert trigger.

CREATE TABLE SourceData
(SomeData VARCHAR(20))

INSERT INTO SourceData VALUES ('abc')
INSERT INTO SourceData VALUES ('def')
INSERT INTO SourceData VALUES ('ghi')
INSERT INTO SourceData VALUES ('jkl')

CREATE TABLE TargetData
(tdID INT Identity(1,1) NOT NULL,
SomeData VARCHAR(20))

CREATE TABLE DataLog
(tdID INT, DateOfEntry DATETIME DEFAULT (GETDATE()))

CREATE TRIGGER tr_i_TargetData
ON TargetData
FOR INSERT
AS
INSERT INTO DataLog (tdID)
SELECT tdID FROM Inserted
GO

INSERT INTO TargetData (SomeDAta) VALUES ('TestEntry')

SELECT * FROM DataLog

Now do a datapump in SSIS 2k5 from source to target and then recheck the DataLog table. The logging will not have fired.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1238469
Posted Thursday, January 19, 2012 2:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Evil Kraig F (1/19/2012)

Now do a datapump in SSIS 2k5 from source to target and then recheck the DataLog table. The logging will not have fired.

But it will if you use the FIRE_TRIGGERS option in the FastLoadOptions property in the Advanced Editor dialog box, right?
Post #1238502
Posted Thursday, January 19, 2012 5:16 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 460, Visits: 215
Took a shot, failed.

At least I learned something.

Thanks for the question.


---------------
Mel.

It's no fun if it's not complicated.

Post #1238565
Posted Thursday, January 19, 2012 5:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 3,856, Visits: 4,996
Good question, thanks.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1238571
Posted Thursday, January 19, 2012 6:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 1:07 PM
Points: 845, Visits: 725
Nice question, and good to know.

It seems many people are guessing at this one, The answers were split 50/50 when I saw it.
Post #1238630
Posted Thursday, January 19, 2012 7:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:29 PM
Points: 21,209, Visits: 14,901
cengland0 (1/19/2012)
Evil Kraig F (1/19/2012)

Now do a datapump in SSIS 2k5 from source to target and then recheck the DataLog table. The logging will not have fired.

But it will if you use the FIRE_TRIGGERS option in the FastLoadOptions property in the Advanced Editor dialog box, right?


Yes




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1238660
Posted Thursday, January 19, 2012 7:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:48 PM
Points: 1,379, Visits: 834
Good question.
Post #1238684
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse