Using source files for DTS packages that are already stored on the SQL Server itself

• Frank Ojeda

  SSC Rookie

  Points: 25

  More actions

  April 10, 2006 at 10:04 am

  #112807

  How can I attach a source file for my DTS package that is acually located on the SQL server itself.  The SQL server has a virtual drive map to a LINUX server that contains files which I want to automate for loading?

  I would like to grab those LINUX text files and load them into my databases.. I want to avoid multiple copies of data files and ensure security.  I am also trying to avoid from copying these LINUX files onto my PC.

   

   

  thanks.

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  April 11, 2006 at 4:23 am

  #631873

  If you have a mapped drive then DTS should be able to access those files.

  Note that this is a SSIS forum, not DTS.

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson