Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Server_Programmer
Starting Member
7 Posts |
 Posted - 2004-10-30 : 17:32:56
|
| Hello Every bodyBrothers I am using SQL-SERVR in my work ,Always I Hear about DTS ,I know it is for transfer Data But I don’t know How can I use it If possible somebody describe it please This Forums Helps to Have More Experiance, So Be As Polite Student |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-10-30 : 19:28:03
|
| DTS is Data Transformation Services and it lets you move (and manipulate) data between two or more data sources e.g. SQL Server, Excel, Access etc. Depending on what you want to do it may be better to use something like BCP. If you want a simple example of how it works you can run through the Import (or export) wizard, save the package and then look at that, but the best source of information on DTS is BOL.steveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-30 : 19:37:26
|
| Have You looked looked in BOL, and read about DTS Or "Data Transformation Services" ?Better still, have You tried to create a DTS package yourself ?Essentially yes, DTS main functionality is to transfer data from A to B.A and B can be different type of sources eg. text, excel, Sql Server, DB2 etc.Also there is other stuff you can do with DTS, like processing cubes, execute sql commands, execute programs etc.You can use VB script in DTSSee this excellent resource on dts: [url]www.sqldts.com[/url]Personally I avoid DTS if I can solve the problem in SQL, which is most of the time.The DTS packages "look" nice, but if you get a lot of them you get maintenance issues,and every time you have to change something you have to open up a graphical UI and click around.SQL is IMO easier to maintain, more robust and more efficient.rockmoose |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-30 : 21:26:57
|
| DTS is a client application that gives methods for manipulating various datasources and workflows for connecting those tasks together.It's important to realise you are working with an application (just like VB or c++) and it runs on the client and needs a connection to the database.One of the things it can fo is move data from one source to another - it is often used for importing / exporting text files which I think it is very innappropriate for.It has it's uses but be cautious about proliferating packages unnecessarily. It needs thought about the design and implementation like any application language.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-11-01 : 15:19:02
|
| Open Enterprise Managerright click the Databases folder>All Tasks>Import Dataand follow the wizard for a simple case then at the end "save as DTS package" rather than run immediately.This creates a DTS package which you can then manipulate via the Data Transformations Services node under packages.It is a quick way to learn about DTS, cause and effect and it is a good lesson in seeing that Enterprise Manager is just a fancy wrapping on the core functionality of MSSQL.I wish someone would start an Official XML Rant Thread. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-01 : 15:26:29
|
| Soon to become.....drum roll please......Brett8-) |
|
|
|
Server_Programmer
Starting Member
7 Posts |
Posted - 2004-11-04 : 00:59:22
|
| Thanks for All really you gave me the good idea about the DTS so ThanksThis Forums Helps to Have More Experiance, So Be As Polite Student |
|
|
|
|
|
|
|
|
What is DTS ?