×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VSS & SSIS

VSS & SSIS

VSS & SSIS

(OP)
I saw my exact problem described in thread1555-1271319: SSIS, VSS, passwords and protection levels but there were no replies yet the thread was closed.  Anyone have a solution?

RECAP: We're saving our SSIS packages in Visual SourceSafe (VSS).  When we develop them, things work fine, but then we have connection error issues when someone checks the package out to edit.  The protection level on the SSIS is  "Don't Save Sensitive".  

When trying to debug the package, it says it can't connect to the server, but when we edit the connection and re-enter the password, the connection test goes fine.

RE: VSS & SSIS

Sounds like the issue is the package protection level.  As you have it as don't save sensitive, none of the connection passwords are saved, hence you're having to re-enter them each time you want to run the package.

There are numerous schools of thought regarding best practice as far as protection levels go - but we've decided to go down the 'Encrypt All with Password' and set a generic password for all packages.

This removed the problem you're having, above, and also removed a couple of the issues around scheduling packages using SQL Server Agent

RE: VSS & SSIS

(OP)
We have re-entered the password and it still gives the error.

We have no problem running this job with SQL Server Agent.

RE: VSS & SSIS

(OP)
With a little (very little) assistance from Microsoft we have found the answer.

Each developer needs to re-create the config file then edit it to add in the Password. (Because we don't save sensitive BIDS/VS won't save the password.)   This allows the 2nd developer to successfully test the package.

Steps:
1.  New developer gets package from source control
2.  In Package Configurations delete the existing configuration.
3.  Create a new configuration, just like the one you deleted.
4.  Save the package and the configuration.
5.  Use notepad to add the password to the configuration.

Runs Great for the new developer.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close