July 21, 2009 at 3:59 pm
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?
July 23, 2009 at 7:35 am
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]
July 23, 2009 at 7:37 am
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]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply