Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2014-11-19 : 16:53:19
|
| Hi, I am having a problem in my SSIS Package. Simple package. First Step:- Using SEQUENCE CONTAINERSecond Step:- Inside SEQUENCE CONTAINER truncating staging table through SQL Task and using data flow to inserting data from .CSV to staging table and then Updating some field through SQL Task.Here is the problem. I am using SEQUENCE CONTAINER when I select SEQUENCE CONTAINER PROPERTIES (transaction Option = REQUIRED). Data flow task stay YELLOW forever. If I change SEQUENCE CONTAINER PROPERTIES (transaction Option = Supported ) everything working fine. Is anyone can help me what I am doing wrong?I know someone want to know why I am using SEQUENCE CONTAINER PROPERTIES (transaction Option = REQUIRED). I want If any task fail everything roll back or nothing happen..Thanks in advance. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-20 : 13:40:10
|
| What you are doing is quite typical. If the dataflow tasks takes a long time it could be because there is a lot of data or the target table is being locked by another transaction. |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-11-20 : 14:28:31
|
| I agree gbritton. This is my local test Database that no one is using, so for sure its not locked by another transaction. I agree if there is a lot of data it will taking long time. My Data Flow is Yellow for Hrs and doing nothing. However If I change the Properties of SEQUENCE CONTAINER (Transaction Option = Supported or Non Supported) taking few Seconds to complete my SSIS Package.Any Advise? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-20 : 16:12:20
|
| Are you running against SQL Server, SQL Server Express or SQL Compact or some other version/edition? |
|
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-11-20 : 16:35:32
|
| I am running against SQL SERVER 2008 R2.Here is my simple SSIS Package detail.First Step:- Using SEQUENCE CONTAINERSecond Step:- Inside SEQUENCE CONTAINER truncating staging table through SQL Task and using data flow to inserting data from .CSV to staging table and then Updating some field through SQL Task. |
|
|
|
|
|
|
Sequence Container HELP