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 |
|
AndyH
Starting Member
3 Posts |
 Posted - 2003-09-14 : 10:45:08
|
| I'm running an ActiveX process inside a DTS package. I'm doing a RegExp to pattern match files in a folder to find .txt files. If i find one I BCP load to a SQL table. This all works when I run on an N/T machine WSH(5.5). They have moved the application long with SQL7sp4 to a Win200 WSH(5.6) machine. Now when the DTS runs the VBscript gets a Runtime error.any ideas ? |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-14 : 13:27:58
|
| And what is this Runtime error?Maybe something like an access violation? |
 |
|
|
AndyH
Starting Member
3 Posts |
Posted - 2003-09-14 : 19:02:57
|
| In the DTS package it just has "A VBscript Runtime error has occoured"Is there away to trap the exact error nessage ? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-14 : 19:43:12
|
| On Error Resume Next....(here your ActiveX script)........MsgBox "Error # " & CStr(Err.Number) & " " & Err.Description |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-14 : 20:40:11
|
| Do you have to use a dts package?It's just a few lines of code in an SP.==========================================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. |
|
|
|
AndyH
Starting Member
3 Posts |
Posted - 2003-09-15 : 12:09:59
|
| Do you have an example of your SP ? Thanks. |
|
|
|
|
|
|
RunTime Error VBscript