DTS - SQL Source to DBase file

• ford_b

  SSC Rookie

  Points: 43

  More actions

  January 16, 2002 at 1:56 am

  #158145

  I have created a package that sources a SQL Server table and outputs to a dbase5 .dbf/.dbt file. This works perfectly well. I then delete the files created by DTS. However, when I save the package to VB the app expects the .dbt/.dbt files to exist. (I would have thought there would be a property to 'createtable') I'd like to be able to create these dbf files/tables on the fly, ie dynamically. Does anyone know how I can do this from VB?

• PAUL717

  Old Hand

  Points: 378

  More actions

  February 6, 2002 at 4:17 am

  #423278

  Using Enterprise Manager to design your package, you can create a dynamic properties task.

  In there you select the connection, OLEDB properties and datasource and SET.

  The you select (ex.) a query like

  select '\\SERVER\DIRECTORY\Subdir\Filename'+(convert (char(6),(SELECT GETDATE()),12))+'.dbf'

  Do not forget to set up the workflow to exec the dynamic properties first.

  This wil create everyday a new file along the date.

• ford_b

  SSC Rookie

  Points: 43

  More actions

  February 6, 2002 at 2:37 pm

  #423359

  Thanks Paul - it works!