Post reply

SSIS Permissions

  • December 20, 2007 at 11:15 am

    #201883

    Hi all,

    I'm new to ssis and have a question about credentials. I have a package that is trying to execute an ftP task and failing. It works fine from my local desktop but not from the SQL Server. Is there a sure fire security model that will ensure that ssis packages will fire from SQL Server.

  • December 21, 2007 at 12:13 pm

    #762275

    Make sure I have this correct...It run's great from your local desktop where you put it together, but if you deploy it to the SQL Server and run it under what I am assuming is the agent it's failing? If so you should read the KB below.

    The SQL Agent needs to own the package to run it.

    http://support.microsoft.com/kb/918760

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

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