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 |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2006-07-17 : 10:10:54
|
We're migrating from SQL Server 2000 to Oracle 9i. We've created and scheduled several DTS jobs that export data into Excel files and email such files. However, now that we're changing Db's, can I create/run a DTS job by extracting data from our Oracle Db? If so, will it plug the data into Excel file successfully??Any light will be appreciated,John  |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-17 : 10:27:43
|
| DTS is a client app. As far as it is concerned sql server is just a datasource the same as Oracle.You might have to change some things due to the different sql but it shouldn't be a problem.Why are you migrating to Oracle? Much more difficult to deal with.==========================================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. |
 |
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2006-07-17 : 15:07:01
|
| Because the company is changing LOS systems. The new LOS works with Oracle.Can you expand on your statements below: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. |
|
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2006-07-20 : 10:33:48
|
| You're right!! I was able to run a package from the Import/Export application connecting to the Oracle Db. Now, can I save and/or schedule DTS packages that connect to Oracle in SQL Server Enterprise Mgr?? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-20 : 11:14:39
|
| All you are doing when you schedule a package is to schedule a dtsexec command line statement (look at the agent). You could run this from the windows scheduler - doesn't have anything to do with sql server.The important statement is "Beer is not cold and it isn't fizzy". I've noticed when working in less civilised countries that beer tends to be cold and fizzy (like lager) and think that probably contributes to the software development difficulties in those countries.==========================================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. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-20 : 13:51:34
|
I strongly tend to disagree on this with you nigel.Beer is good only if it's cold. On fizzy i semi agree  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Can DTS work extracting from Oracle Db?