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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-07 : 05:28:42
|
| Dear friends,dts and bcp works with client tools? is export and import is nothing but DTS or something other is there?thankyou very much. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-07 : 06:20:47
|
| They are both client tools.bcp just needs bcp.exe but needs to connect to sql server.dts isn't really anything to do with sql server - just is distributed with it and can connect to it. Think of it as similar to an application language like VB or c#.==========================================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. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-07 : 07:14:21
|
| and one moreis dts is nothing but export and import? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-07 : 07:52:35
|
| Nope - dts has lots of tasks available. Open it and look at the task list.Why are you asking?==========================================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. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-07 : 09:14:42
|
| http://sqldts.com is a good source for all things DTS. That will give you some idea of what you can do with dts.there is also a great DTS reference book here http://sqlteam.com/store.asp. I would recommend getting that book if you are going to be doing any serious DTS work.-ec |
|
|
|
|
|
|
bcp dts works with client tools?