create a text file for the DTS

• sar99

  Old Hand

  Points: 351

  More actions

  December 27, 2006 at 9:06 am

  #174256

  Hello,

  I want to create a text file which has the one variable in the steps which is getting the data from a table, as in the following example: The only varibale is chnging in the pattren is the @value which is getting it from a table called tbldatabases:

   

  @test-2=1

  @value= Northwind

  @test2=4

  ---------------

  @test-2=1

  @value=pubs

  @test2=4

  ---------

  @test-2=1

  @value=msdb

  @test2=4

  -------------

   

  Which way is the better way to create the file ?

  Thanks for the help.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 28, 2006 at 12:25 am

  #680218

  If you want use DTS then check GLOBAL VARIABLES option...

  OR

  You can do the BCP in combination with xp_cmdshell using tsql too...

   

  MohammedU
  Microsoft SQL Server MVP

• jfb

  SSCrazy

  Points: 2469

  More actions

  December 28, 2006 at 7:34 am

  #680254

  Maybe you can use lookups for this challenge

  http://www.sqldts.com/default.aspx?277,4

  Rgds

  Johnny