I need to insert data returned from an ActiveX vb script into a table. Can
I do this w/o writing the data into a text file (inside the vbs), then
importing the text file into a table? Right now I out it in a file, then
load the file into the table. I'd like to go straight from the vbs script
into the table.

Here is an example of the vbs output data:
Class_CD,0
CWY_CD,0
Dev_CD,10
GHS_CD,10
Master_CD,90
MET_CD,10
Prior_CD,10
PSC_CD,0
STJ_CD,10
UAM_CD,10
Warehouse_CD,95

Here is a select of the table data:

SampleName SampleSize
--------------- -----------
Class_CD 0
CWY_CD 0
Dev_CD 10
GHS_CD 10
Master_CD 90
MET_CD 10
Prior_CD 10
PSC_CD 0
STJ_CD 10
UAM_CD 10
Warehouse_CD 95

I am not really sure what you are after here. is the "vbs output data"
generated within the Active Script task and "table data" is what it would
look like in the destination?

if the answers to the above are true then you are quite simply looking at
ADO programming in VBScript.


http://msdn.microsoft.com/library/de...df_ax_06er.asp


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"cw" <cwilson (AT) 3mc (DOT) com> wrote