|
|
 |
| 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 p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
December 11th, 2007, 10:15 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
DTS migration from 7.0 to 2005
Hi All,
I am trying to migrate my SQL Server 7.0 server to 2005 on a new box.
I am having trouble migrating the DTS packages. It shows an error, for which I got the solution on Microsoft site as "Installing SQL Server 2000 tools". But My current database is 7.0, is there anything like "SQL Server 7.0 tools"??
- Vishu
__________________
- Vishu
|
December 14th, 2007, 04:50 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Is it necessary to install these tools, is there no alternative?
- Vishu
|
December 14th, 2007, 06:11 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Any mods here???
- Vishu
|
December 14th, 2007, 06:42 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 2,922
Thanks: 0
Thanked 13 Times in 12 Posts
|
|
SQL Server 2005 doesn't use DTS although it supports running legacy DTS packages from within the SQL Server Integration Services (SSIS) framework. I suggest you look at SSIS in the 2005 BOL.
--
Joe ( Microsoft MVP - XML) |
December 19th, 2007, 12:33 PM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hey...I am not trying to run the DTS from Legacy...I have migrated them to SSIS and saved as flat files...
Problem is that the DTS I am talking about is connecting to Oracle ...
and it gives me the following error "Unable to case COM object of the type system._comobject to interface type dts.customtask...."
- Vishu
|
December 19th, 2007, 12:40 PM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
It also says something anout the Oracle Net8 connectivity... whast is that??
- Vishu
|
January 25th, 2008, 05:12 PM
|
|
Authorized User
|
|
Join Date: Jun 2007
Location: Delhi, New Delhi, India.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Finally it all got solved...the problem was DTS designer package not being installed on the server.
We didnt installed DTS designer on the server but rewrite all the data pump tasks to corresponding Data Flow Tasks in SQL 2005.
With the drivers available with ADO.NET, connectivity to Oracle was never an issue.
- Vishu
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
