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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-04 : 09:53:18
|
| Adrian writes "I have the following code which successfully runs a DTS package in SQLServer v7. However when it is run against a DTS package in SQLServer2000 SP2 (win2000) nothing happens. It appears to run & there are no error message but it has done nothing. The DTS package works fine when executed on its own.Set dts_pkg = Server.CreateObject("DTS.Package")dts_pkg.LoadFromSQLServer strServer, strUser, strPass, , , , , strDTSNamedts_pkg.ExecuteSet dts_pkg = NothingHelp much appreciated.ThanksAdrian" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-04 : 19:52:31
|
| If your package works fine "on its own" which I assume means when you run it directly from Enterprise Manager, but fails when called from ASP, then I'd look into permissions. How are you logging into your SQL 2000 database? How are the permissions different between your login and the web page's login? What is your package doing?--------------------------------There's a new General in town... |
 |
|
|
ajvb
Starting Member
1 Post |
Posted - 2002-02-05 : 05:21:48
|
| Was a permission problem. Changed the dB connection in the package to use a SQLServer account rather than NT. The package then ran successfully from the ASP page.Thanks for your help.Adrian--------------------MUFC - The Religion.Edited by - ajvb on 02/05/2002 05:23:37 |
|
|
|
lily
Starting Member
6 Posts |
Posted - 2004-08-06 : 13:11:52
|
| [quote]Originally posted by ajvbsend me the code how do u did it as i need itThnxemail code and specifications at fun2oos@rediffmail.com |
|
|
|
|
|
|
Running DTS From ASP