Home Forums SQL Server 2005 T-SQL (SS2K5) Running SSIS package with other domain account RE: Running SSIS package with other domain account

  • March 24, 2014 at 5:32 am

    #1699474

    mahesh.yerragonda (3/24/2014)

    For ssis configurations,I used sql server table where the password gets picked from table.

    Right now it is encryptsensitivewithuserkey,I tries using donsavecasesensitive but when open the package with admin account then I'm getting errors.

    I need to run this package both with user and admin account.Please help/

    If the protection level is DontSaveSensitive and passwords come from a SQL Server configuration table, everything should be fine.

    What are the errors when you open the package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP