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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy