SQLTeam.com | Weblogs | Forums

SSIS Referring to Text in a package level object


#1

I am developing a table driven ETL system, where I store large PL/SQL queries in a varchar(max) field. I read the field into an object variable at the package level using a SQL task. Next I have a C# script task that creates a connection to our Oracle database using the Oracle provider. I am trying to set the command.Text property to the PL/SQL statement I've stored in the package level object variable, but I'm having difficulty getting the Pl/SQL text back out of the object. I've tried Object.value.tostring, but it just returns a generic "object__text". I have been researching this for awhile now, but I haven't found a good solution. Does anyone have any ideas on how I can proceed?:unsure:


#2

This is a SQL Server forum. PL/SQL is Oracle IIRC.