Look at the sample after the word sample, how can I insert a sourceFields from the IM?.
Hi.
How can I insert a specific field in the integration manager for this code?.
Sample:
-------------------------------------------------------------------------------
Command.Parameters.Append(Command.CreateParameter("@PropertyValue", 200,1, 133, "SourceFields(a field from sales transaction)"))
------------------------------------------------------------------------------
set connectionPuma = CreateObject("ADODB.Connection")
set command = CreateObject("ADODB.Command")
connectionPuma.ConnectionString = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=test;Initial Catalog=Development;Data Source=gemini"
connectionPuma.Open()
command.ActiveConnection = connectionPuma
command.CommandText = "sp_InsertarFacturaMagaya"
command.CommandType = 4
Command.Parameters.Append(Command.CreateParameter("@ObjectType", 200, 1,31, "SOP"))
Command.Parameters.Append(Command.CreateParameter("@ObjectID", 200, 1,61,SourceFileds("Type.invoice")))
Command.Parameters.Append(Command.CreateParameter("@PropertyName", 200,1, 31, "GUID"))
Command.Parameters.Append(Command.CreateParameter("@PropertyValue", 200,1, 133, "TESTING"))
command.Execute()
connectionPuma.Close
