Post reply

SSIS & File System Task Security question

  • January 2, 2009 at 7:37 am

    #197645

    Does anyone know what permissions SSIS's File System Task uses when being debugged from a local desktop?

    I'm part of an AD group that has Full Control rights on the share I'm trying to read from and the SQL Server Agent service also has Full Control rights on that share, but I'm getting an "Access is Denied" error message on the share.

    The only thing I can think of is that BIDs on my desktop is trying to use a different account or that my pass-thru security isn't working correctly. Thoughts?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 2, 2009 at 8:15 am

    #920293

    Nevermind! My problem isn't a security issue. I forgot to write out my path variables in my Script task so the File System Task could find the source & destination properly.

    DOH!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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