March 8, 2002 at 3:53 am
Guys, Am in need of urgent help. I tried saving a DTS package in the 'Repository Packages' section of Data Transformation Services section but somehow that package is not visible in that section (Rep Packages)even when I refresh that section. However, I can view that DTS package in the 'Metadata' package section. But how can I actually open that package and edit it..?? I am not able to figure that out. Any help will be deeply appreciated...
Also in case I schedule a DTS package as a job that job does not appear in the list of jobs that should be there... !!!
Rohit Kaul
Rohit Kaul
March 8, 2002 at 6:13 am
Try this in QA,
SELECT [Name] FROM msdb..RTblNamedObj WHERE [Name] = 'YourPackageName'
If not found then it did not save properly and I believe you will just have to recreate. Otherwise need to dig into the problem.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply