SQL Server Performance

ssis - import-export

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Feb 4, 2008.

  1. arkiboys Member

    An excel spreadsheet has to be open on Machine B on the network to pull data from a third party tool.
    I have to refresh several columns in this spreadsheet every minute with new data.
    Every time there is a new data into the columns i.e. columns 7 and 10, the spreadsheet pulls data from the third party tool automatically and populates other columns i.e. columns 12-15.
    Then I will have to retrieve the new data from the spreadsheet into sql server 2005.
    So first I wrote a query to use to populate the spreadsheet each time with the result using Import Wizard.
    It gives an error: 0xc0202009
    And I am not sure if my approach for this project is correct?
    What do you think?
  2. ghemant Moderator

    Can you please double check if the proper permission are assigned for the SQL Agent and Proxy account for temp directory!!
  3. satya Moderator

Share This Page