SSIS Connection String issue

• cmbrooks08

  SSC Eights!

  Points: 861

  More actions

  July 21, 2009 at 3:59 pm

  #212466

  I'm using an SSIS package config file to store connection strings to my data sources. After a lot of troubleshooting, I realized that the ampersand in the title of an access database isn't encoding properly? Here's the string-

  Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\odapps3\dcgnrl\lev&war.1.mdb;Jet OLEDB:Database Password=admin

  The ampersand in the data source is what I'm talking about. I've tried escaping it with \ and / and neither worked. I also tried with just the & itself, and that didn't work...any ideas?

• Brian Knight-400586

  SSC Enthusiast

  Points: 136

  More actions

  July 23, 2009 at 7:35 am

  #1028943

  Hello,

  Because the configuration file is stored in XML, you need the symbolize your ampersand. Try converting your & to &. I think that will have you on your way. Please note the semicolon at the end.

  Thanks,

  Brian

  [font="Tahoma"]Brian Knight | http://mindyourbiz.spaces.live.com | @mindyourbiz[/font]

• Brian Knight-400586

  SSC Enthusiast

  Points: 136

  More actions

  July 23, 2009 at 7:37 am

  #1028945

  Jeez, the forum converted my symbology to a &!

  I mean do this: type "&", followed by an "a", followed by a "m", followed by a "p", followed by a ";".

  Brian

  [font="Tahoma"]Brian Knight | http://mindyourbiz.spaces.live.com | @mindyourbiz[/font]