🔒 Closed Pa help naman po regarding sa dts connection sql

Status
Not open for further replies.

marcopolo01314

Journeyman
Meron po akong DTS package na ginawa and also have Global Variable on it..I'm trying to use the Global Variable created by DTS but I encountered some error..

Error : "Login failed for user dbIDdestCon"

Eto po yung code ko


Dim oGlobal As DTS.GlobalVariable
Dim dbIDdestCon as String

Set oGlobal = goPackage.GlobalVariables.New("db_DestID")
oGlobal = "sa"
dbIDdestCon = oGlobal
goPackage.GlobalVariables.Add oGlobal
Set oGlobal = Nothing

oConnection.Name = "Connection 1"
oConnection.id = 1
oConnection.Reusable = True
oConnection.ConnectImmediate = False
oConnection.DataSource = "*************"
oConnection.UserID = "dbIDdestCon"
oConnection.ConnectionTimeout = 60
oConnection.Catalog = "**********"
oConnection.UseTrustedConnection = False
oConnection.UseDSL = False

patulong naman po sa marunong pong mag program :(
 
Status
Not open for further replies.

Similar threads

About this Thread

  • 0
    Replies
  • 528
    Views
  • 1
    Participants
Last reply from:
marcopolo01314

Trending Topics

Online now

Members online
531
Guests online
12,407
Total visitors
12,938

Forum statistics

Threads
2,362,776
Posts
29,417,480
Members
1,055,324
Latest member
roberto bm
Back
Top