December 12, 2011 at 5:52 am
One of our maintenance package has been failing. This package has been created by our previous DBA and I don't know whether it worked. So, I need to troubleshoot and fix it.
This is the background info:
1. Package runs on SQL Server 2005
2. It is saved in msdb.
I exported the package as test file and tried to open it in BIDS. How do I go about debugging this package to see where it is failing.
I tried to start debugging from BIDS but it did not seem to do anything.
Can I someone point a good link to help me troubleshoot it?
December 12, 2011 at 5:59 am
You need to create a new project and add the package to the project. Then you can use the button with the green triangle to run the package (or any of the tasks in it) interactively.
John
December 12, 2011 at 5:59 am
You need to add the package to an SSIS solution in BIDS in order to debug it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 12, 2011 at 6:34 am
Is there a link or write-up that I can refer to do this?
December 12, 2011 at 6:47 am
ashanair70 (12/12/2011)
Is there a link or write-up that I can refer to do this?
I searched the internet for "create solution in bids". If you do the same, you'll find plenty of helpful stuff.
John
December 12, 2011 at 7:32 am
John Mitchell-245523 (12/12/2011)
ashanair70 (12/12/2011)
Is there a link or write-up that I can refer to do this?I searched the internet for "create solution in bids". If you do the same, you'll find plenty of helpful stuff.
John
And don't forget "ssis add existing package". Very helpful stuff too.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply