Hi - I'm trying to lookup table DTS_parameter_table - column PARAM1 for a value and stuff it into global parameter that i have setup in my dts..... My global variable is called "part_num"The activeX script needed to do this is below but i am getting an error ----------------------Error Code :0Error Source = Microsoft SQL - DMO (ODBC SQLState:28000)Error Desc.[Microsoft][ODBC SQL Server Driver}{Sql Server} Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connectionError on Line 9----------------------line 9 i believe is oServer.Connect ".", "sa" Questions i have is :Suppose my pwd for account 'sa' is 'pwd001' then what is the syntax to enter the pwd in the oserver.Connect line ??Is there any other way i can easly pass a parameter to a DTS other than this method ??Function main()Dim oServer 'DMO Server object.Dim oResult 'Result set.Dim sParamValue 'Create a SQLDMO server object. Set oServer = CreateObject("SQLDMO.SQLServer") ' Make a connection to the local server. oServer.Connect ".", "sa" 'Select the desired row from the table. set oResult = oServer.Databases("vanguard").ExecuteWithResults_("select param1 from DTS_Parameter_Table") 'Retrieve the first row, first column from the results. sParamValue = oResult.GetColumnString (1,1) 'Set the global variable. DTSGlobalVariables("part_num").Value = sParamValue Main = DTSTaskExecResult_SuccessEnd functionthanks for any help
CANT SEEM TO FIGURE OUT WHATS WRONG
Posted - 2008-10-31 : 09:58:05
