[cfaussie] Re: VB and MSSQL

Tue, 28 Oct 2003 16:48:27 -0800

Steve you can definetly write ActiveX scripts (vb script) for DTS transformations, and i have done this numerous times with no problems. Depending on the scenario you have, the standard way is to create a DTS transformation or package, and then create your ActiveX scripts within that package. A good example we have used recently, was to pull a heap of phone numbers from an Oracle database and transform this data into an MSSQL table making sure that all phone numbers were purely numeric when they reached the MSSQL table. So in the DTS package I just added a small ActiveX script which manipulated the phone numbers (some contained dashes, spaces, and even words) into straight numbers as they passed through row by row.

Hope this helps,

Phil


Taco Fleur wrote:
I'm not sure if DTS (Data Transformation Service) would do the trick? But I know you can call objects from sql code within the MSSQL RDBMS, so I assume you could call VB.

Lookup anything to do with objects in MSSQL online help.

Hope that helps.


-----Original Message-----
From: Steve Onnis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 29 October 2003 8:55 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: VB and MSSQL


thanks
will have to have a look into some dts then

steve

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Steve Baty
Sent: Tuesday, October 28, 2003 7:17 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: VB and MSSQL


Steve,

I've seen this done via DTS (Data Transaction Service??) in MS SQL. A
DTS package called both app server pages, and VB apps. Afraid I'm not a
db developer, so I can't give you any guidance beyond that - but I am
confident you can do what you've asked.

HTH

Steve Baty
-----------------------------------
Steve Baty - senior analyst
p: 612 8596 4030
m: 0412 061 292
f: 612 8596 4001
e: steve @redsquare.com


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve
Onnis
Sent: Tuesday, 28 October 2003 7:07 PM
To: CFAussie Mailing List
Subject: [cfaussie] VB and MSSQL

Does anyone know if you can call VB straight from MSSQL from like a
trigger
or something?

Steve


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004




---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to