Hi Shwetha,

Do U wanna deploy the DTS packages from one Sever to other ? OR

Do you wanna move the DTS packages (Code ) from one Server to other?

If it is...

I think this stuff is gonna sit in sysdtspackagelog and sysdtssteplog tables in MSDB database.

There would be also few other tables starting with "sysdts" check them out too.

# "sp_dump_dtslog_all" can...

Hi Archana,

Well there would be alot of things we need to take into consideration before finding the root cause for your problem.

First of all have you configured your both Servers...

Hey John,

you can create any Security ROLE and assign what all permissions you wanna give to all the persons present in that group and then add any new Users to...