Currently, one cannot assign a variable as an OLEDB source using EzAPI. Assignment does not raise an error or exception but the associated property, SqlCommandVariable, is never set. This results in the generated package not having a source assigned which in
turn results in the package raising an error of 'Accessing variable "" failed with error code 0xC0010001'
The order of operations does not matter, both generate the same XML.
this.Source.AccessMode = AccessMode.AM_SQLCOMMAND_VARIABLE;
this.Source.DataSourceVariable = this.Variables["sourceQuery"].QualifiedName;
I modified EzComponents.cs, line 1027 of changeset 65381 to modify the setter for the DataSourceVariable property. This necessitates the order of operations being
Set AccessMode to AM_SQLCOMMAND_VARIABLE
but I don't care as it works. Someonewill undoubtedly have a better understanding of what the proper holistic solution is. The AccessMode check was required because I had also used a variable in my destination and an access mode of AM_OPENROWSET_FASTLOAD_VARIABLE
doesn't allow a property of SqlCommandVariable.
if (AccessMode == AccessMode.AM_SQLCOMMAND_VARIABLE)