dbTalk Databases Forums  

Re: copy a password protected dts package from one server to antoh

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: copy a password protected dts package from one server to antoh in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: copy a password protected dts package from one server to antoh - 12-03-2006 , 03:36 AM






Hello qjlee,

Once you have transferred the package it is still encrypted using the package
password. How will you execute it? How do you execute it now? Do you DTSRun?

DTSRun stores all the details you need to be able to retrieve the package
from storage and execute it including password if any.
Do you use an encrypted cmd line to execute the package? This means you
cannot see the DTSRun string. If you do use an encrypted cmdline then maybe
if you google maybe you will find a utility that can reverse this cmdline
string into something readable and hence give you the password back.




Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
These are local packages, and I believe in another of my question you
refer me to an article about transferring dts packages. What kind of
issue will be around executing it?

Thanks,

"Allan Mitchell" wrote:

Hello qjlee,

You can certainly transfer it from A --> B but the issue will be
around executing it.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
Hi,

I have a dts package which is password protected, and I don't have
the password. Is there anywhere to copy from SQL server to anotoher
sql server?

Thanks,




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.