marcopolo01314
Addict
- Joined
- Jul 5, 2016
- Posts
- 75
- Reaction
- 5
- Points
- 82
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
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