Transaction in ssis

  • Hi all,

    I have problem in setting transaction option as required.

    I have one sequence container.in that i have one dataflow task using this i'm copying data from one table to another.then i have one execute sql task connected to that data flow. if this sql task fails i need to rollback data flow task.

    I tried this one by setting package transaction as 'required'

    and sequence container property as 'Support'.property of all task also supported only.

    When i'm executing package data flow task fails.

    But without this transaction option it runs correctly.

    both in local and server dts is running.

    The following error it shows:DTS_E_CANNOTACQUIRECONNECTIONMANAGER

    the aquireconnection method call to the connection manager 'user' failed.

  • I have changed mstdc security options its working now..

    but another issue..

    in that i'm accessing data which is populated by first data flow task in second data flow task ...it get struck their.. i think its because of table lock ...how deal with this....

    DATAFLOW1...SOURCE:emp TARGET:emp_tgt

    DATAFLOW2...SOURCE:emp_tgt TARGET:emp_tgt1

    like this...my flow got struck in dataflow2..because of transaction...

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply