hide source code in SSIS

Question

hide source code in SSIS

sunnyepgc

Mr or Mrs. 500

Points: 546
More actions
February 25, 2016 at 3:40 am

#316259

Hi I have few SSIS package which are called from UI application.In order to run these SSIS packages I have to deploy these dtsx packages to machine where application has been installed.My requirement here is to hide the source code of the ETL(dtsx package). How to achieve this??
Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15681 More actions · Answer 1

There's no way to fully obfuscate the SSIS source code. However, you could set the package setting for Package Protection to EncryptAllWithPassword, which would require a decryption password to view the source code.

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

sunnyepgc Mr or Mrs. 500 Points: 546 More actions · Answer 2

Thanks for the reply. But here in this case ETL packages will be run by customer,if we set protection as EncryptAllWithPassword we have to share the password with them to run the package.I want to hide the source code from the customer. Is there any other way to handle this.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

I don't know whether this is an option for you, but you can encrypt your package (or parts of it) by user key, which means nobody would ever need to know the password. You would need somebody on the customer site to help the customer encrypt the package with the user key of the account that would run the job (typically the SQL Server Agent service account). It follows that anyone who knows that password for that account can decrypt the package, so you may not be comfortable doing this for customers who are less than strict with their password controls.

John