Hi,
I need to add two oledbcommand tranformations in my package.
i add the commands like this:
--
this.OledbCommand1 = this.dataflow.ComponentMetaDataCollection.New();
this.OledbCommand1.ComponentClassID = "DTSTransform.OleDBCommand.1";
this.OledbCommand1.Name = "ChangingColumnAttribute";
this.OledbCommand1.Description = "ChangingColumnAttribute";
CManagedComponentWrapper oledbinstance = this.OledbCommand1.Instantiate();
oledbinstance.ProvideComponentProperties();
this.OledbCommand2 = this.dataflow.ComponentMetaDataCollection.New();
this.OledbCommand2.ComponentClassID = "DTSTransform.OleDBCommand.1";
this.OledbCommand2.Description = "UpdateHistoryColumnAttribute";
OledbCommand2.Name = "OleDBCommand2";
CManagedComponentWrapper oledbinstance1 = this.OledbCommand2.Instantiate();
oledbinstance1.ProvideComponentProperties();
-
i get the following error message during package validation:
OnError
ErrorCode -1073451000
Source DataFlow
SubComponent DTS.Pipeline
Description The package contains two objects with the duplicate name of "compone
nt "OLE DB Command" (719)" and "component "OLE DB Command" (701)".
Please advice.
Look at setting "IdentificationString" for each of your items.|||I get the following output for Identification Strings:
OledbCommand1 Component: "ChangingColumnAttribute" (701)
OledbCommand2 Component: "OLE DB Command" (723)
Regards,
Sriharsh
|||Do you need to add "this." to the line where you set the name for OLEDBCommand 2?|||Adding "this" did not help.
Still get the following error message:
Description The package contains two objects with the duplicate name of "component "OLE DB Command" (723)" and "component "OLE DB Command" (701)".
-
this.OledbCommand1 = this.dataflow.ComponentMetaDataCollection.New();
this.OledbCommand1.ComponentClassID = "DTSTransform.OleDBCommand.1";
this.OledbCommand1.Name = "OledbCommand1";
this.OledbCommand1.Description = "ChangingColumnAttribute";
this.OledbCommand2 = this.dataflow.ComponentMetaDataCollection.New();
this.OledbCommand2.ComponentClassID = "DTSTransform.OleDBCommand.1";
this.OledbCommand2.Name = "OledbCommand2";
this.OledbCommand2.Description = "UpdateHistoryColumnAttribute";
No comments:
Post a Comment