Hi, I have developed a package with protection level as 'Encryptsensitivewithuserkey' and i have used sql server authentication for connection strings. I did not notice that when i was developing it. Now when i am running the package with option 'Dontsavesensitivedata' the package is throwing up errors. Are the errors because of the protection level . Should i use windows authentication or sqlserver authentication when the protection level is 'Dontsavesensitivedata' I dont want to redevelop the package. its big. Please help.

Without posting the exact error, it's hard to know. The errors are more than likely to do with your connection string as 'DontSaveSensitive' will result in passwords being blanked out. have a read of http://msdn.microsoft.com/en-us/library/ms141747.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

here is the error [Execute SQL Task] Error: Failed to acquire connection "medcdr2.CDR_Main.thr1". Connection may not be configured correctly or you may not have the right permissions on this connection. thanks

here is the error [Execute SQL Task] Error: Failed to acquire connection "medcdr2.CDR_Main.thr1". Connection may not be configured correctly or you may not have the right permissions on this connection. thanks What about the rest of my post: The errors are more than likely to do with your connection string as 'DontSaveSensitive' will result in passwords being blanked out. have a read of http://msdn.microsoft.com/en-us/library/ms141747.aspx Have you looked into this?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD