how come the validation doesn't seem to end keep on running?

Hi folks,

it is me again. Just want to enquire how come with the control flow of the Data flows been set appropriately, why when it is executed manually in the sql server 2005 file system, the validation shows the incorrect flow of data flows been executed and doesn't seem to end? Thanks in advance

Regards,

Ken

Hi Ken,

It's probably just me combined with the fact I've had no coffee yet, but I don't follow. Can you restate the issue?

Thanks,
Andy

|||

Hi Andy,

Thanks again for helping this newbie. Ok I have input my package into the SQL Server 2005 file system located under Stored Packages. I run them manually which displays a validation report on its progress. But i notice from the validation report that it doesn't run the validation check as how I drew the flow of the components and it seems to be running endlessly. Is there a way to edit the package so that it can signal the end of the package.

|||

Hi Ken,

You are most welcome - I was a newbie myself not long ago.

If I'm understanding you correctly, either your package is stuck in Validation (or appears to be) or stuck in execution (or appears to be).

If the package is stuck in validation, you can change the Package level property DelayValidation to True. The package will load and attempt to run. Any errors will likley cause it to crash, but it may give you insight into why it is behaving in this fashion.

If the package is stuck in execution, I suggest you implement logging. Also consider custom logging using Execute SQL Tasks on the Control Flow and in OnError event handlers.

Hope this helps,

Andy

|||Are you executing child packages from a parent package, by any chance?