SSIS tasks was not executed?

Question

SSIS tasks was not executed?

wwei

SSC Eights!

Points: 961
More actions
April 23, 2010 at 3:18 pm

#156902

Hi All,
I have a simple package, it was running OK. But I don't know for what reason, it suddenly does not work well.
The problem: when I run the package in BIDS, the package shows 'Package execution completed', but none of the tasks in the package was executed. Attached shows the screen shots.
In Prograss tab: it just shows: 'Validation has started' and 'Validation is completed'.
If any of you knows about it, please help.
Thanks in advence!!!

Viewing 5 posts - 1 through 4 (of 4 total)

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

Phil Parkin SSC Guru Points: 246693 More actions · Answer 1

That's strange.

Something must have changed - you just have to find out what. Source? Target? Windows update? Something else in the package?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

divyanth SSCarpal Tunnel Points: 4303 More actions · Answer 2

That's really strange.. Is the package corrupted ? Did you try running each task separately ??

wwei SSC Eights! Points: 961 More actions · Answer 3

Hi All,

Thank you for taking a look, and willing to help me.

I tried looking for something related...

And I tried run an individule task (by disabling all other taskes, if there are some other way to run an single task, please let me know, thanks!), not working either.

Thanks again.

RexSmith SSC Eights! Points: 997 More actions · Answer 4

Create a table called "todelete" with just column "errordesc varchar(100)"

Create a dummy sql task.

just put a "insert into todelete values ('xxxxxx')

search for that record after script is run

this will prove if your code is being executed or not.

Else best alternative is to create a new project for same functionality

Rex Smith