Help! I am trying to get a sybase SQL anywhere database converted to a SQL
server 2005 express database. I have done it with DTS in SQL server 2000 but
it is killing me trying to figure it out with SQL server 2005

Specifically, i would like to figure out a process that can do this
automatically for each of like 100+ customers. (that is why I say SS2k5
epress, i am going to distribute to them the express version.)

the database is very basic, there are like 30 tables(with a ton of rows)
and no stored procedures or triggers or anything else. I just need to
transfer all the data, I already have all of the table structure set up
(identical for source and target databases)
I can think of 2 ways:
1. there is already a ODBC datasource to the database set up on each of
these systems. so do an exact replica using ODBC
2. get all of the data to SQL INSERT statements (which I cannot figure out
how to do either)

thanks anyone for any help!