SteveD SQL (8/28/2016)
Hi,Is it possible to...
1) create an empty, no rows, Object Variable from a table structure. Possibly with a SELECT * FROM XYZ where 1=2
2) Add records to the Object Variable in multiple places through a package.
Basically the goal is to gather issues, not errors, that have occurred during the package run, importing data from a 3rd party, into a Object variable. The contents of the variable would be written to a table and subsequently a 'Run Report' would be sent back 3rd party either saying the report ran successfully with no issues or had issues, see attached.
Thanks
Steve
I've certainly written C# in the past which will read from an object variable which is already populated, so I think it should be possible.
Outside of C#, you'll struggle to do this, so if you're not into scripting, I suggest you consider alternatives. Maybe a raw file could be used to store the results ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.