Hi!
Does anyone know of a way to dynamically create an Access database from
scratch in a DTS package to be a destination?
Would this require a custom task? How do you create that? I thought I
found some code, but I couldn't get anything to work, probably due to
my
lack of VB knowledge.

Thanks for whatever help anyone can provide!

Carolina

To create an empty database you'd have to either copy an existing file
or invoke the Access Application object and create a DB using the
Access object model. You could use an ActiveX script task in DTS to do
this.

Once you've created the database the DTS transform tasks can create
tables for you.

--
David Portas
SQL Server MVP
--

David,
Thanks!
Any chance I could get some help with the ActiveX script? That's
exactly what I want to do. Any chance this will overwrite the
previously created empty database file as the process runs regularly?
Thanks for your help!

Carolina