Usage of Global Variables in SSIS question....

• Selva Jayakar

  Valued Member

  Points: 52

  More actions

  October 16, 2006 at 1:53 pm

  #666070

  You can define variables in SSIS packages and use them in expressions in source and destination connections.

  Here is some reading

   

  http://msdn2.microsoft.com/en-us/library/ms141105.aspx

• Brandie Tarvin

  SSC Guru

  Points: 173108

  More actions

  October 18, 2006 at 6:01 am

  #666445

  Here's a link to a post I made on Tek-Tips about this issue.  It regards switching .ini files to the Global Variables in SSIS.  I hope it helps.  If not, let me know.

  BTW, you have to have a sign in to access Tek-Tips.  It's free.

  http://www.tek-tips.com/viewthread.cfm?qid=1262822&page=3

   

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.