Got it!

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

dim mySQL

Function Main()

dim oPK,sqlParam,myTask

set oPK=DTSGlobalVariables.Parent

set myTask= oPK.Tasks("DTSTask_DTSDataPumpTask_1")

set sqlParam=myTask.properties("SourceSQLStatement")

sqlParam.value=LoadSQL

Main = DTSTaskExecResult_Success

End Function

Rocker you put me on the right path. Stuck an Active X script...

Getting closer with firing an Active X script before rest of package.

*****************************************

' Visual Basic ActiveX Script

'*****************************************

Dim objConn, objPkg

function main()

Set objPkg = DTSGlobalVariables.Parent

Set objConn = objPkg.Connections("excelconn")

objConn.DataSource=objPkg.GlobalVariables.Item("strpathfile").Value

Main = DTSTaskExecResult_Success

end function

'*****************************************

I'm right...

Rocker much thanks.

I get the jist of that and will give it a go.

Thanks again Rocker,

Not there yet though. Back to my original post, if you cannot use sql source loader params with 7.0 like 2k, can I still do what I...

Thanks Rocker,

lol

I am not currently having the problem in the ASP. The problem I am experiencing is perhaps a difference between 7.0 and 2000.

From what I have read seems...

The Column is not computed.

Example of data in xls column

758ghf

463304

ghdfj7

451121

The items that are numeric in value come thru as nulls. The table column they go into is a varchar.

Has anyone...

To all those interested in Passing Params from ASP to execute DTS package look at this link.

http://www.asp101.com/articles/carvin/dts/default.asp

Excellent Article as primer. Do the Following.

1) Create DTS package, add global...

I have just found the wonderful world of executing dynamic DTS packages from ASP.

The package in particular starts off by taking in an input param transforming some data from one...

Just some of the values for that column are turning up null after the DTS, the ones that were numeric.

I am doing ONE transformation for all values involved...

Hello again,

I am using SQL2K. I am making ground in passing params. Actually I am trying to pass them from ASP. In the DTS my Source is an...

Good to hear

Thanks

Thanks for the Replies,

My original plan was to use the FSO to get the file, then have DTS pour it into SQL DB

The reason for my post is I...