Post reply

SSIS, DTEXEC,Problem with dynamically setting the connectionstring

  • August 6, 2009 at 12:45 am

    #1035206

    Wendy,

    this error most often occurs when the account specified exists in Windows, but is not associated with any SQL server rights. It could be that you have forgotten to specify the domain of the user, misspelled the user name or did not add it to the group that has rights on the SQL server, or any likewise error.

    WM_HOPETHATHELPS

    Guenter

  • August 6, 2009 at 7:40 am

    #1035354

    Hi Guenter ,

    Thank you for your help.

    I am using SA account, not windows’ domain account. If I have all user info plugged in the package, it can run successfully. When pass in the parameters by connectionstring, it doesn’t not work. Does anything to do with package protection level?

    Thanks,

    Wendy

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

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