July 14, 2003 at 1:21 am
Hi,
I want to migrate 120 access database data to
single sql server 2000 database.
Structure of the sql server database is different than access database.How can i do this using DTS wizard.If any one has any idea about that?
thx in advance.
July 14, 2003 at 7:29 am
Hi,
You can perform a loop DTS package, here is an example to get the idea.
http://www.swynk.com/friends/green/dtsdirloopstep.asp
JFB
July 14, 2003 at 7:30 am
After you have selected the MS Access table to copy into your SQL Server, you will come to a screen that says "Select Source Tables and Views". When you select your table, scroll all the way to the right until you see a Transform column. Click on the ellipses [...]. There you will find how to identify columns, etc. for the transformation. The screen is labelled Column Mappings and Transformations.
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply