all groups > sql server (microsoft) > october 2007 >
You're in the

sql server (microsoft)

group:

How Create Job to Export->Access that Picks Up New Columns & Tables Without Re-Creating


How Create Job to Export->Access that Picks Up New Columns & Tables Without Re-Creating Peter Lakanen
10/25/2007 5:53:56 AM
sql server (microsoft):
Running SQL Server 2000.

I want to create a scheduled job that will export all the tables in a
database to Access. Yes, I know about DTS, but here's the thing...
Once I set up the DTS package, if I add a new table (or a just add a
new column to an existing table), that DTS package isn't going to
export that new table (or column) to Access.

This means that every time I create a new table, I have to re-create
the DTS package (can't figure out how to edit the package using that
useless GUI designer tool).

I've been Googling the newsgroup archives and I've seen other people
with this problem, but I haven't discovered the solution.

Do I need to write something in ActiveX using SQL DMO? If so, any
hints?

Is there an easy way to edit the DTS package?

Any other suggestions?

Thanks!

-peter
AddThis Social Bookmark Button