I have a dtsx pckg which selects data from source which is sql server and copies to oracle env using vb scripting in ssis. now currently my pckg has the connection string as
Provider=MSDAORA.Oracle;Data Source=<dbname>;User Id=<userid>;Password=<pwd>;
to set up a connection to destination env. i am trying to have this pass as a variable to this script. is this possible? I tried to
declare a string at pckg level saying Destconnection which has the entire string (Provider=MSDAORA.Oracle;Data Source=<dbname>;User Id=<userid>;Password=<pwd>;)
and then use that as readonly variable in script property. somehow when using a
MsgBox(Dts.Variables("DestConnection").ToString) i dont see the value getting passed onto script. am i doing something wrong or missing something? any help will be greatly appreciated. TIA