how to read XML Packgae Configuration

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  July 9, 2009 at 1:02 am

  #208075

  Hi,

  I have created the xml package configuration in one of my package, also created the enviornmental variable for xml pkg config. file which tells me Config. file path. I have created the excel filepath in the XML config file.

  Now what i want to do is the Excel connection I hva ein my packgae shud take the connection string which is declared in xml config file.

  How Can i achive this?

  -Abhijit

  Abhijit - http://abhijitmore.wordpress.com

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 13, 2009 at 3:58 am

  #1023760

  Hi Abhijit,

  Declare a string variable in the package.

  in the Excel Connection Manager, Reference this variable for Directory.

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers