Post reply

Making Sql Server Agent Account to access the remote file which is a source of Dataflow task

  • October 20, 2009 at 12:04 am

    #215597

    Hi,

    How can i make Sql Server Agent Account to access the remote file which is a source of Dataflow task

    Thanks

  • October 20, 2009 at 12:39 am

    #1067979

    Your question is a little ambiguous..

    You want to use the login that your SQL Agent to access a file that is a data source in a dataflow task?

    From where, SQL Agent, BIDS? Where?

    CEWII

  • October 20, 2009 at 1:33 am

    #1068000

    hi,

    i have a data flow task whose source connection flat file is a csv file located in remote location,the import of data works fine in bids and under msdb,but fails under sql agent as job when scheduled

    Please help on how can i resolve thins

    Thanks

  • October 20, 2009 at 1:41 am

    #1068004

    It sounds like you need to have permissions setup for that file. My guess is that the user that SQL Server uses to login doesn't have permissions on that file. so you find out what user SQL logs in as and have the powers that be grant rights to where the file is.

    CEWII

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

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