April 19, 2011 at 7:33 am
Hi All,
I created SSIS package in SSIS 2008 and tested the same from BIDS. It executed successfully.
I deployed and scheduled on SQL Server.
When its triggered for running the package, the Package hangs...and going to sleep mode.
It doesnt give any error/event info to the log file.
The log shows the info abt previous tasks only.
No info abt the processtask that whether "executing" or "failed to execute"..
I have included on Pre execute, On progress and post exection...no info abt any of these three.
Plz help me ASAP...
Thanks in Advance
Sasidhar P
April 19, 2011 at 7:39 am
--Edit
What does the package do?
If you put a script task as the very first task in the script (and write a log file / database entry) at least you will be able to tell whether the package begins to execute.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 19, 2011 at 9:39 am
Thanks for response.
Yes...
The first is Execute SQL task and next is SCript task...Then after this Process task will execute the batch file.
When i execute it by double clicking it prompt me allow to run the command like Installing the software, we will get some untrusted publisher like that...
Awaiting Ur response...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply