I've treid to assign connection variables by rowset. ie.

Dim oCon
Dim oR

Set oRS = DTSGlobalVariables("RSTables").Value ' This is the output para. of "select source_server from table
Set oConn = DTSGlobalVariables.Parent.Connections("Sybase ASE OLE DB Provider") ' This is the source connectio
oConn.DataSource = oRS.Fields(0).Value

The error says it doesn't load the data source. why?

Is that definitely the name of your connection?

What is the exact error?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"DTS beginner" <anonymous (AT) discussions (DOT) microsoft.com> wrote

What is the fuull error, and what line of code does it get raised on?

If it is reading the field value -

Have you checked the value of oRS.Fields(0).Value

Try adding a debug message box-

MsgBox oRS.Fields(0).Value
oConn.DataSource = oRS.Fields(0).Value


--
Darren Green
http://www.sqldts.com

"DTS beginner" <anonymous (AT) discussions (DOT) microsoft.com> wrote

The error says it cannot load the data source.

I can fix it by trim the rowset value ie. Trim(oRS.Fields(0).Value)

Thanks anyway.