January 16, 2002 at 1:56 am
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?
February 6, 2002 at 4:17 am
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.
February 6, 2002 at 2:37 pm
Thanks Paul - it works!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply