none
Package Exporting to File System

    Question

  • I am exporting the package to the file system from the production. When exporting the default is showing as 'Encrypt Sensitive data with user key'. Does this have any impact when I open it for development? Should I go with 'do not save sensitive data' option?
    Thursday, January 16, 2014 10:16 AM

Answers

  • I am exporting the packages from the production to the file system and providing to the developer

    If you're giving it to others then whatever you do they wont be able to see sensitive information used by you insidepackage. In that case if you want them to open and run packages you should ask them to manually fill in those details like pointing to their development server and databases, change variable values etc.

    Another option is to create a configuration inside package storing all sensitive information and store it in a XML file (.dtsconfig extension). Then edit the file to change production values with corresponding development values ie development server, database etc. Then sent them the file also along with package and tell them to put file in folder the package points to inside configuration settings. Then they would be able to open and run package with development environment settings without adding anything manually.

    see

    http://www.sqlis.com/sqlis/post/Easy-Package-Configuration.aspx


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, January 16, 2014 11:36 AM

All replies

  • it wont have any impact for you. It will make sensitive info only available to you like connection manager properties,connectionstring etc. So when somebody else opens package they wont be to able to see it unless they use your credential to login

    In case you chose 'do not save sensitive' setting, sensitive info never get stored in package at all. So if you want to again open package in BIDS and do some change you have to again enter all connection manager etc details yourself before runing. 


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, January 16, 2014 10:20 AM
  • Hi Visakh,

    I am exporting the packages from the production to the file system and providing to the developer. They will develop the packages. In this case will it affect them?

    >>So when somebody else opens package they wont be to able to see it unless they use your credential to login

    So you mean to say the developers wont be able to see?


    Thursday, January 16, 2014 10:24 AM
  • I am exporting the packages from the production to the file system and providing to the developer

    If you're giving it to others then whatever you do they wont be able to see sensitive information used by you insidepackage. In that case if you want them to open and run packages you should ask them to manually fill in those details like pointing to their development server and databases, change variable values etc.

    Another option is to create a configuration inside package storing all sensitive information and store it in a XML file (.dtsconfig extension). Then edit the file to change production values with corresponding development values ie development server, database etc. Then sent them the file also along with package and tell them to put file in folder the package points to inside configuration settings. Then they would be able to open and run package with development environment settings without adding anything manually.

    see

    http://www.sqlis.com/sqlis/post/Easy-Package-Configuration.aspx


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, January 16, 2014 11:36 AM