Home Forums SQL Server 2005 Development How call flat file from another server using dtsx ? RE: How call flat file from another server using dtsx ?

  • What are you trying to do?

    Import flat files from Server1 into a database on Server2?

    If so ensure that you have setup the correct file shares, use UNC paths in your SSIS package and ensure that the nessesary security has been applied to the share so that the SQL Agent or the proxy account used to run the SSIS package has access.