x

OLE DB Destination should error but waits (task box is yellow).

The problem is that the input data recently changed and duplicate records were in the data flow going to a table that had a primary key to prevent this. Instead of the task failing it just waits.

I have a dataflow task which has a Script Transformation Editor task flowing to a derived column task flowing to a OLE DB Destination task.

I tried a simple test reading from a table with duplicate records to a table with a primary key to stop it and it fails instead of waiting. The project is now in SQL 2008 and it was converted from SQL 2005. The test was written in SQL 2008.

Other fatal errors are trapped and handled but in this case the task just sits there until it is stoppped. In the mean time I have worked on the input data to stop the duplicate records.

Any help or ideas would be greatly appreciated

bob
more ▼

asked Jul 23, 2012 at 03:05 PM in Default

rdavidson51 gravatar image

rdavidson51
0 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

My first suspicion would be that the SSIS is waiting on the database engine. Can you see from SSMS what is going on - a long transaction, blocking, locking etc? If you dont already have it then get sp_whoisactive from Adam Machanic and use it to see what is occurring.

more ▼

answered Jul 24, 2012 at 09:00 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x21

asked: Jul 23, 2012 at 03:05 PM

Seen: 484 times

Last Updated: Jul 24, 2012 at 09:00 AM