SSIS Package Hangs after Not Responding - Validating Incremental Load

Question

SSIS Package Hangs after Not Responding - Validating Incremental Load

Welsh Corgi

SSC Guru

Points: 116520
More actions
April 24, 2012 at 8:17 am

#267853

I have a problem where a very large SSIS Package Hangs after Not Responding.
In the bottom left hand corner it displays "Validating Incremental Load".
This is not the name of the package so I'm not sure where it is getting this from.
I suspect that the package is corrupted.
Is there a way to recover?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

A false alarm perhaps It is validating each transformation now at a snails pace.:-D

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I click on debug and nothing...

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Welsh Corgi (4/24/2012)
I click on debug and nothing...

It's probably validating everything again 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I'm trying to delete task from it and it takes about an hour per task.

I tried selecting several tasks at a time but it hangs.

I need to edit this package in XML.

It has EXEC SQL Tasks and a Transformation Task in the COntrol Flow with OLE DB SOurce & Destination in the Data Flow.

I need to be careful what I remove from the XML FIle.

I wish that there was a DTS equivalent to Edit Offline.

Thanks for the reply.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

It takes approximately 5 minutes to delete a task.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

I'm still deleting at a snails pace.

It is taking a lot longer to delete.

I create those task a lot faster and then it went down hill.

It is as if the package is corrupt.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 7

A few things.

1) Restart Visual Studio/BIDs. the cache occassionally gets wonky.

2) Go through the package and look for OLEDB sources that are using stored procedures and the like. Make sure the property ValidateExternalMetadata = FALSE

3) Instead of mass deletes, copy/paste the couple of components you want to a new package and avoid the old one if it's causing that much heart-ache.

- Craig Farrell

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

:-):-):-)

Evil Kraig F (4/25/2012)
A few things.
1) Restart Visual Studio/BIDs. the cache occasionally gets wonky.
2) Go through the package and look for OLEDB sources that are using stored procedures and the like. Make sure the property ValidateExternalMetadata = FALSE
3) Instead of mass deletes, copy/paste the couple of components you want to a new package and avoid the old one if it's causing that much heart-ache.

Craig,

Thanks for your reply.:-)

I have restarted BIDS repeatedly.

I have several SP's that I use for logging, other than that I have 1 Exec SQL Task to Exec a SP as opposed to a Data Transformation task.

Thanks for the help.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/