Hello, Michael.

An excellent stored procedure.

It would be beneficial to create this in a database where all database utilities are stored and send the fks database name as an additional...

Thanks for the quick reply.

The barcodes are bmp images that are stored in a table in an Oracle database. I believe a range of barcodes have bee populated in the...

What error message do you get when you register your 2000 instance in Management Studio and then drill into legacy and try to open a DTS package?

You may need to...

PS:

I should have included a step to have these rewritten to SQL Server Integration Services packages as soon as they can be.

bourgoin

Two things. You should migrate your existing DTS packages to the new SQL Server 2005 instance. This is relatively painless.

Then, create a new role in the MSDB database....

I have the same issue, with the exception that my SSIS package runs fine from the command line on my desktop, but fails on the server from both command line and...

I ended up creating a new role in msdb and granting that role permissions needed to access the DTS packages. I then added our developers to this role. This was...

Has anyone resolved this issue? I cannot get any user logins to access legacy DTS packages in SQL Server 2005 without specific permissions at a very high level.

Any help would...

Mr. Dillard, has this positioned been filled?

Thanks.