Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  data migration from access

Author  Topic  s121701 Starting Member 6 Posts Posted - 2007-01-15 : 02:59:15 hi.i have question regarding migration. data i m migrating need to be transformed first. I am transforming data in access first and then using dts packages in sql to migrate that data. for example for one table transformation steps (using access) includes selecting info from different tables then run make new table query and then manually inserting auto number key from access design view(as i need to give new identity key for the table). My question is can I reduce all these steps using access or sql dts packages to perform the transformation in fewer step.that will save time as I need to transform quiet few tables. I am new to sql server. can someone please help!!