I have a global variable (ImportFilename) that acts as the Datasource (ASCII filename) that is used in a dynamic properties task. It works fine when executed from within the pkg or even externally when the default property setting is used. I have tried many iterations to get the syntax correct in passing a new value to it from the call but can't seem to get it.... cannot find any Books Online or programming reference example....
Code flow:
exec usa_runcreditvoiddtspkg -- starts the process
<inside procedure>
... initial lines of code including the LoadFromSQLServer
...
declare @filename as varchar (100)
set @Filename= '\\svrname\c\inetpub\EXEC @hr = sp_OAMethod @oPKG, 'Execute',null, @ImportFilename=@Filename
Returns the error:
OLE Automation Error Information
HRESULT: 0x80020006
Source: ODSOLE Extended Procedure
Description: Unknown name.
Another try:
declare @filename as varchar (100)
set @Filename= '\\svrname\c\inetpub\EXEC @hr = sp_OAMethod @oPKG, 'Execute',null, @Filename
Returns the error:
OLE Automation Error Information
HRESULT: 0x80020011
Source: ODSOLE Extended Procedure
Description: Does not support a collection
Thanks in advance!
...
...
Code flow:
exec usa_runcreditvoiddtspkg -- starts the process
<inside procedure>
... initial lines of code including the LoadFromSQLServer
...
declare @filename as varchar (100)
set @Filename= '\\svrname\c\inetpub\EXEC @hr = sp_OAMethod @oPKG, 'Execute',null, @ImportFilename=@Filename
Returns the error:
OLE Automation Error Information
HRESULT: 0x80020006
Source: ODSOLE Extended Procedure
Description: Unknown name.
Another try:
declare @filename as varchar (100)
set @Filename= '\\svrname\c\inetpub\EXEC @hr = sp_OAMethod @oPKG, 'Execute',null, @Filename
Returns the error:
OLE Automation Error Information
HRESULT: 0x80020011
Source: ODSOLE Extended Procedure
Description: Does not support a collection
Thanks in advance!
...
...