I have migrated the DTS packages to SQL server 2005(standard) from SQL2000
using the migration wizard. The packages are under integrarion services/msdb.
I have installed the Backward Compatibility, DTS designer components. How can
i schedule the packages? how do i edit the package?

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

You should find the DTS packages under the Management -> Legacy -> Data
Transformation Services branch in SQL Management Studio. If you're lucky,
and everything you need is installed, right-click a package and choose Open.
I was recently working on a few packages for a client. Editing was
problematic, but mostly worked. Some of the icons were invisible, but
passing the mouse over them, or clicking to select them, made most of them
visible. After I had saved the packages once, the icons stayed visible.

I don't know about scheduling them since I wasn't doing that. If nothing
else, maybe you can use the Execute DTS Package step in an SSIS package and
schedule the SSIS package.

"art" <art (AT) discussions (DOT) microsoft.com> wrote

Thank you for the info Paul. I see the folder Data Transformation Services
under Management/Legacy, but the packages are under integration
services/msdb. That's were it went when i migrated the packages.I tried the
ssis-execute DTS package- but got the message cannot find the package msg. I
am not sure if i have to do anything different..

thanks much for ur response.

"Paul Shapiro" wrote: