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 |
|
Django
Starting Member
3 Posts |
 Posted - 2003-07-09 : 01:43:57
|
| Does the DTS run inside the SQL server or outside it? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-09 : 06:03:52
|
| DTS is a client application and has the same relationship to sql server as any other application.When you run dts it will run on the client m/c.I wish it was released with studio rather than sql server then maybe people wouldn't think it was part of the product and use it properly.==========================================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. |
 |
|
|
Django
Starting Member
3 Posts |
Posted - 2003-07-10 : 02:55:22
|
| Thanks for the reply.... |
|
|
|
Django
Starting Member
3 Posts |
Posted - 2003-07-10 : 03:10:26
|
| So if we have only the client in our PC, can we create the package in our PC and run it? And is it possible to run the DTS package in the server? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-10 : 03:26:06
|
| dts is included with the client tools so if you have enterprise manager and query analyser you will also have the ability to design, load and execute dts packages - think of it as like VB. Note it is important to apply service packs to the client as dts has had a lot of fixes.The server also gets the client tools which include dts.Note that it is run under the client account profiole. If you load the designer to run the package it will be your own logged on account.If you use dts run from a scheduled job then it will be the sql server service account that runs the package.==========================================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. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-07-10 : 07:24:34
|
quote:
So if we have only the client in our PC, can we create the package in our PC and run it?
quote:
dts is included with the client tools so if you have enterprise manager and query analyser you will also have the ability to design, load and execute dts packages
That's kinda like saying "If I have a computer with Internet Explorer installed, but no internet connection, can I surf the web?" ... "If you have Internet Explorer you will have the ability to surf the web" ... I think that's a little misleading nr.DTS is a client application, true. And it is also true, that you can use the DTS object library (say in a VB application) if you have the client tools installed. However, if you don't have a server (somewhere), what you can do with DTS is limited (useless). If you have Enterprise manager installed, but no servers registered, you won't be able to use EM to design, load or execute a damn thing.DTS runs under the context of the client (using the client credentials), but it does stuff to SQL Servers, not clients.Jay White{0} |
|
|
|
|
|
|
|
|
Where does the DTS run?