June 20, 2008 at 6:41 am
I apologize if this has been discussed, but I can't seem to find any specific forum topics that address this issue, and i'm at a deadline that I must meet today. Any help would be most appreciated.
We were forced to update a server from SQL2000 to SQL2005 this week. I got all of the databases over, and I ended up moving all of the DTS packages over. I ended up migrating the DTS jobs into SSIS, and I can actually execute the packages and have everything complete to 100%.
I've created the jobs to run the SSIS packages, using the SQL Agent Service Account. When I try to run the job, it fails with the error: The package execution failed. The step failed.
I've never used SSIS before, so at this point, i'm considering scrambling to make the DTS packages run, but I wanted to see if anyone could give me some ideas before I did that.
Again, thanks in advance.
June 20, 2008 at 6:49 am
Welcome to SSIS.
First off, buy a SSIS book and play with the samples. Its actually not that difficult.
but for your immediate requirement, I would suggest that you switch on package logging. Read up in BOL on package logging.
This will give you a more verbose description of what your error is.
I also think that you are looking at the wrong place in your job scheduler - click on the plus button, and you will see the steps in your job, which will give you more of a description. HOWEVER, very often this description really doesnt give you much to work on.
Good Luck
~PD
June 20, 2008 at 7:06 am
Thanks for the welcome...I think... 🙂
If I had the time, I would love to be able to play and figure it out. But I don't have that luxury right now. I will be doing it once this silly project is over and I can read the SSIS book.
At some point in time, someone created the DTS packages that we need, and I still have access to those. What I can't find is the 2005 equivalent of DTSRUNUI so that I can get the package identity to run it through command line.
Those are a couple of options that I have.
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply