Post reply

Impersonation in SSIS

  • April 9, 2011 at 3:22 am

    #97819

    I have a network shared folder, where my files are placed. SSIS has to use a generic windows account to access the file on shared. how will i do that?

    I tried with proxy, its not working. i have tried impersonation, didnt get it.

    how will i know where i am doing wrong?

    any help will be great.

    thanks.

  • April 9, 2011 at 5:01 am

    #1309530

    Hi,

    SSIS related questions should be posted on this forum (SQL Server 2005 Integration Serviceshttp://www.sqlservercentral.com/Forums/Forum148-1.aspx)

    Anyway, I guess that by Generic Windows Account you mean local account which is not a domain account. Did you verified that account has read access to the share?

    You could execute

    runas /user:GenericWinAccount cmd

    and by using shell with valid security context try retrieving the file from the file share (e.g. Xcopy, explorer). If you are using Local Windows Account you should create a copy of this account on the destination server with the same name and password and grant it with read permissions to the file share.

    Cheers, Max

    Check-out free open-source utility Sql Server Replication Explorer[/url]

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

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