SSIS global variables and package variables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS global variables and package variables

SSIS global variables and package variables

Rate Topic

Display Mode

Topic Options

Author

Message

mullen_john

Posted Tuesday, September 01, 2009 12:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 02, 2009 6:24 AM
Points: 3, Visits: 19

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).

Cheers!

Post #780970

John Rowan

Posted Tuesday, September 01, 2009 1:11 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Read up on package configurations. This will allow you to set your package up to pull in values from environment variables, registry entries, xml files, etc. You should be able to create a solution where multiple packages pull from the save variable store.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #780998

mullen_john

Posted Tuesday, September 01, 2009 2:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 02, 2009 6:24 AM
Points: 3, Visits: 19

Thanks John, Where would I get the details on package configurations. Would you be able to provide a link?
Cheers!

Post #781082

John Rowan

Posted Tuesday, September 01, 2009 3:05 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Google SSIS package configurations and you'll get a heap of info. Here are a few worth reading:

http://msdn.microsoft.com/en-us/library/ms141682.aspx

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #781098

mullen_john

Posted Wednesday, September 02, 2009 6:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 02, 2009 6:24 AM
Points: 3, Visits: 19

Thank you John!

Post #781370

« Prev Topic | Next Topic »

Permissions