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 - 2003-03-05 : 07:46:30
|
| Russell writes "I am working with SQL Server 2000 on a Compaq Server running MS Windows 2000 (5.00.2195 SP3)From my PC or separate laptop (both Win98) I have no issues with the execution of DTS packages. My problem is when I am running SQL Server Enterprise Manager from a Terminal Services session. Terminal Services allows me direct access to the server so that I can assign ODBC connections and eventually schedule the packages to run as a sql server agent job.I was recently granted access to Enterprise Manager using the terminal services session. My first test was to create an ODBC connection (to an Oracle/Rdb database on a Vax) and test that the connection worked. I created a simple DTSDataPumpTask within a DTS package. The PREVIEW worked, it displayed the data retrieved from the VAX system. I went into the PROPERTIES of the TRANSFORMATIONS and hit the TEST button to validate the transformation. The test worked, I was able to view the results. However, when I exited back to the design sheet (it did not matter if I said OK or CANCEL to get back) the Enterprise Manager locked up. Task Manager indicated "not responding" as soon as I looked at the job.This condition existed every time I used the TEST button. It also occurred when a DBA who supports me ran the TEST function. So I assume it does not have to do with my personal privileges while in terminal services. Running the same TEST from my laptop or PC will work fine and not lock up.Is this a known bug with terminal services / WIN2K / etc. ? My resource has no idea why it is happening and wanted to know if I could code without using the TEST button. Hence my question to you.Thanks,Russell Altersitz, Walklett Group (contractor for DuPont)" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-05 : 14:47:10
|
| I do not ever use the TEST button when using transformations in DTS packages and I create a lot of DTS packages that use the transformations task.Tara |
 |
|
|
|
|
|
Active-X TEST button locks up Enterprise Manager