asked on

Transfer Encrypted SQL Objects from one server to another using Transfer SQL Server Objects Task

I wish to transfer Stored procedures from one server to another using Transfer SQL Server Objects Task in SSIS.

In that due to some of encrypted SPS and for those SPs my transfer task goes fail.

Please guide me the way how to do

SThaya

you need to decrypt those SP's first then you can go for the transfer. please check the below links

http://connect.microsoft.com/SQLServer/feedback/details/244285/transfer-database-task-fails-with-encrypted-stored-procedure

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/840b9841-8b23-480c-af74-0d21a60df062/

SThaya

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dc53bab1-d196-499e-8159-c0011eb618bf/

EugeneZ

also you can recreate the proc (if you have code somewhere or from start)
restore the all DB on the destination and use this proc from there

decrypt using 3rd party tools (try on your own risk):
http://www.sql-shield.com/support/decrypt-stored-procedure
Decrypt SQL Server Objects
http://www.sqlmag.com/article/encryption2/decrypt-sql-server-objects-95728

even, you can open MS case to help this decrypt

ASKER CERTIFIED SOLUTION

Alpesh Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Alpesh Patel

ASKER

Created list using sys query and assigned to ProceduresList property