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 |
|
smithje
Starting Member
32 Posts |
 Posted - 2004-02-10 : 16:42:52
|
| We can no longer run DTS pckgs from a stored procedure or query. Corporate decision to move our databases to a server farm and our user logins do not have rights to access the command line. We can no longer use any of the commands that call DTSRUN because they all need access to the CMDSHELL. This includes scheduled jobs being called with sp_start_job. Does anyone know how to export the code from a DTS package or create the functions of one in transact SQL? Can exported code be run in a query or an ASP page? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-10 : 16:53:49
|
| You probably can't use the sp_oa SPs either?http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.htmlI think you'll have to redesign to not use dts (maybe a good thing).==========================================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. |
 |
|
|
smithje
Starting Member
32 Posts |
Posted - 2004-02-10 : 17:23:28
|
| "a good thing", maybe. But we have no clue how to do that. The spoils of having a wizard? Where can I find examples of queries that perform import functions from excel files or text files? |
|
|
|
|
|
|
Execute DTS without CMDSHELL