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 |
|
Haarish
Starting Member
30 Posts |
 Posted - 2009-08-24 : 00:53:55
|
| Hi All,I have a data flow task that populates a stage table with values. I have another data flow task succeeding the previous task where I populate a dimension table with values from the stage that are not already existing in the dimension table. The OLEDB source is from a query:SELECT T1.* from Stage_Table1 T1where T1.Col1 NOT IN (SELECT T2.Col1 from Dimension_Table1 T2)The query when executed on the management Studio executes without any issue, but in the SSIS data flow task it simply does not proceed. The Data flow task is YELLOW in colour without proceeding any further. The same query on the Mgmt Studio takes less than 1 second to execute. Any ideas why this could be happening?Thanks in advance,Haarish. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-24 : 05:44:35
|
| Are there any other tasks in the package?While the task is executing in SSIS, check for any related blocks in SQL Server (Activity Monitor).Also check the Transaction Isolation level of the package. |
 |
|
|
|
|
|
SSIS - Comparison