Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS-Access Queries

Status
Not open for further replies.
HLPCH

HLPCH

IS-IT--Management
Jul 12, 2004
47
US
Hi, I am creating a package to transfer data from MS Access to SQL Server. I used the connection object to specify the Source and Destination. I know the Transfer Data task would transfer data from each of the tables from Ms Access. However I wanted to know if the DTS had the capability to transfer Access queries to SQL as a Stored Procedure or Views.

If so what do I need to use ?

Please help!

SS.
 
Status
Not open for further replies.

Similar threads

Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
172
Fsoumia
Fsoumia
WordTechinc
  • Locked
  • Question
DTS disable Daily Run 1
Replies
1
Views
90
drlex
drlex
Aluminum
  • Locked
  • Question
DTS Raiserror messages suddenly stopped displaying
Replies
0
Views
79
Aluminum
Aluminum
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
111
mrdenny
mrdenny
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
76
mutley1
mutley1

Part and Inventory Search

Sponsor

Back
Top