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

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.

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

hello
i am raghuvar .i want to know that how i can convert my complete sqlserver database into .csv format of database

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.