December 17, 2003 at 11:49 am
I need to import data into an access database on a weekly basis. Each week I need to create a new table with a with a time stamp in the name. What is the best way of doing this dynamically in the DTS Package?
December 18, 2003 at 9:24 am
If you are going to do this in DTS you will:
1. Create
a) Access DB Connection
b) Execute SQL Task
c) ActiveX script Task
2. Make Workflow(on complete) starting From ActiveX to the Execute SQL Task
3 on the ActiveX get current date and change the SQLStatement Property of the Execute SQL task as CREATE TABLE YOURTABLENAME (field1 type, ...)
HTH
* Noel
December 18, 2003 at 9:34 am
Thanks for your help.
Actually this is exactly how i figured it out. The hard part is determining Object names, but Disconnected edit really helps out in this section.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply