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: 246965 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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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 Ten Centuries Points: 1027 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