Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 6th, 2004, 07:21 AM
Registered User
 
Join Date: Jan 2004
Location: Damitta, Damitta, Egypt.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to galaxy@net Send a message via Yahoo to galaxy@net
Default What is DTS?

Text
Hi every Body
Merry Christmas
Iam New Devolper In SQL Server 2000
& Iwant To know For What WE USe the DTS , I have Used it for Convert XLS SpreadSheets to SQL Tables


GALAXY
  #2 (permalink)  
Old January 6th, 2004, 09:17 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,409
Thanks: 0
Thanked 16 Times in 16 Posts
Default

DTS is Data Transformation Services
You use it to transform data. The source and destination of a transformation can be any one of many options (SQL Server, Access, Excel, text files, other database systems...). You can create DTS jobs and schedule them do get automated functionality out of SQL Server for regular tasks. We use them to generate CSV files for client reporting, also to transfer data to our test and production database servers, backup, all sorts of things. A DTS job can contain any number of tasks (object copying, VBScripts, command executions, etc) and can be related and dependent upon one another so that you can set up a linear execution plan for the tasks (versus them all running at once).

It is a very powerful tool, although the design interface can be a real pain to work in.

Peter
------------------------------------------------------
Work smarter, not harder.
  #3 (permalink)  
Old January 6th, 2004, 06:29 PM
Registered User
 
Join Date: Jan 2004
Location: Damitta, Damitta, Egypt.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to galaxy@net Send a message via Yahoo to galaxy@net
Default

But , When I try To Use DTS to Export The following ERR
Cannot Find"MyDB" in Sys_linked Server
context :Error Calling GetRowSet To Get DB_Schema Tables Schema info
yr provider all the schema rowset rquired by DTS
this ERR Msg only for my Custom DB
it doesnot appear For Northwind DB

GALAXY
  #4 (permalink)  
Old November 26th, 2007, 04:08 AM
Authorized User
 
Join Date: Oct 2007
Location: delhi, delhi, India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hello
i am raghuvar .i want to know that how i can convert my complete sqlserver database into .csv format of database
  #5 (permalink)  
Old November 26th, 2007, 04:14 AM
Authorized User
 
Join Date: Oct 2007
Location: delhi, delhi, India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hello ,
i want to convert my sqlserver2000 database in .csv format .
can you tell me how i can convert.
please hurry up it's urgent thanks.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
New to DTS jasimbo SQL Server DTS 0 October 7th, 2005 06:28 AM
New to DTS nals SQL Server DTS 3 May 18th, 2005 04:06 PM
New to DTS jitu SQL Server DTS 3 June 3rd, 2004 01:05 PM
dts calls a lot of dts steffi_ma SQL Server DTS 2 May 24th, 2004 07:18 PM
DTS problem :( meemee SQL Server 2000 1 March 4th, 2004 05:49 AM



All times are GMT -4. The time now is 07:17 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.