DTS Scripts (SQL Server 2000)

Hello,

I would like to know the DTS Scripts for converting Access Databases to SQL Server 2000. The Access Databases are located on multiple servers. The tables should be created the first time. Then the data should be copied from Access Databases located on multiple servers. No duplicate rows should be added to SQL Server tables. The data should be copied from Access Databases every 15 minutes. Please show me a example (code in DTS Scripts) which does this task.

Thanks,

Vivek Gupta

You can use import export wizard in SQL enterprise manager and it will create DTS package for your, next you just have to modify it to accept input access file name as parameter, and maybe table name in it? But if your table structure is different in each database it will be hard to create single DTS package because DTS package will store table structure definition as fixed. Maybe instead of this you can write simple .Net application which will do this for your for any Access database location and table name.

Thanks