I am new to SSIS.
I need to know how to create variables to be used in multiple packages of a project.
I am converting an Access application running on a local PC to be run as a SQL Server Agent job.
I need to create global variables to be used by many other packages in the project.
It appears I can create variables local to a package but not usable by any other package.
Would anyone be able to tell me how to accomplish this?
Remember I am new to this SSIS and do not know all the basic.
Presently I am using an Execute SQL Task Toolbox Control Flow Item's SQL Statement and a Connection Manager of Native OLE DB\Microsoft OLE DB Provider for Oracle (MSDAORA.1).