DTS package with a parameter

• Roust_m

  SSCoach

  Points: 17410

  More actions

  December 17, 2006 at 10:02 pm

  #115839

  Hi,

  I need to import a great number of text files into database.  I am thinking about creating a dts package and using it with file name as a parameter.  Is there a way to pass a parameter to  a DTS package?  If not is there a possibility to script a DTS package so to be able to create it dynamicaly, then run it and then drop it and recreate it again with different text file as a source?  If all this is not possible, what other options exist?

  Thanks.

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  December 18, 2006 at 3:46 am

  #678592

  You create a global variable "ImportFileName".

  Then in your call to dtsrun you add the following parameter:

  dtsrun ....  /A "ImportFileName":8=C:\MyFolder\MyFile.txt"

  Then you use a Dynamic Properties task to set the DataSource property of the text connection.

  Russel Loski, MCSE Business Intelligence, Data Platform

• mrpolecat

  SSCertifiable

  Points: 7014

  More actions

  December 18, 2006 at 2:19 pm

  #678808

  If the list of files is in a table you could build a DTS loop to import all of the files.  If you want to import all of the files in a directory you can do it like this:

   

  http://www.sqldts.com/default.aspx?246

  ---