Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 30th, 2008, 01:07 AM
Authorized User
 
Join Date: Jun 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Now the problem is how do i create the table in sql server with the same structure as the table in access.

 
Old January 30th, 2008, 01:13 AM
Friend of Wrox
 
Join Date: Oct 2007
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi
Default

sql server has option to import data, right click on database and some where you will fine import, follow the dialog box, select final.mdb, the process will import all tables with relevalant data types.

urt
 
Old January 30th, 2008, 01:15 AM
Authorized User
 
Join Date: Jun 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

no can't use this method.
I need to automate this task. As this will be a weekly process that needs to be done.

 
Old January 30th, 2008, 01:21 AM
Friend of Wrox
 
Join Date: Oct 2007
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi
Default

In that case you need to create a vb or vb.net application which reads data from access and update sql server, also this application must to sheduled to run weekly.

urt
 
Old January 30th, 2008, 01:34 AM
Authorized User
 
Join Date: Jun 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes,

I want to write a DTS for this.

What i intend to do is,

first get the columns names of each tblTEST and write a create table sql and create a table and then import the data.

to do this do you know how we can get the column names in DTS may be by using activex script

 
Old January 30th, 2008, 06:23 AM
Friend of Wrox
 
Join Date: Oct 2007
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi
Default

Sorry I dont know about DTS with activx script.

urt





Similar Threads
Thread Thread Starter Forum Replies Last Post
varying data range stealthdevil Excel VBA 6 July 27th, 2007 02:30 AM
append record whith do while function iisha64 Access VBA 0 February 19th, 2007 09:24 AM
Import Data from Open Excel Sheet to Access chintu4u Pro VB Databases 0 May 15th, 2006 01:24 AM
Import Excell Data into Access Mitch Access 4 February 15th, 2005 10:29 PM
Editing Access and import data edramail Access 2 May 7th, 2004 02:27 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.