|
Home > Archive > MS SQL Server DTS > July 2005 > Insert data from an ActiveX script
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Insert data from an ActiveX script
|
|
|
| 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
| |
| Allan Mitchell 2005-07-26, 8:24 pm |
| 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/d...ddf_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@3mc.com> wrote in message
news:erpccXgkFHA.1412@TK2MSFTNGP09.phx.gbl...
>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
>
>
|
|
|
|
|