October 2, 2012 at 10:50 pm
Hi all,
In my package i have one sequence container,in that i have 3 data flow task ...each one access data from previous data flows target tables data.....
Sequence containers transaction level: required
all 3 data flow task transaction level:supported
isolation level :serializable
DATAFLOW1.SOURCE:excel_source TARGET:cust_stagging,product_stagging,sales_stagging
DATAFLOW2.SOURCE:cust_stagging,product_stagging TARGET:cust_dim,product_dim
DATAFLOW3.SOURCE:sales_stagging,cust_dim,product_dim TARGET:sales_fact
my flow got struck in dataflow2..because of transaction...without transaction its running fine...but i want to roll back if any dataflow task fails ...so i need transaction...
I think need to change isolation level ...any suggestions.....
Thanks and Regards
Sathiyan.R
October 3, 2012 at 1:57 am
This was removed by the editor as SPAM
October 3, 2012 at 2:08 pm
Transactions and SSIS are... painful at best. However, make sure that your connections that you're using in your transactions are set to reuse same connection (keep connection... something like that, you'll know it) in the datasource properties. If you don't, you end up with multiple connections from the different objects blocking other components.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply