Just to confirm, you're rt-clicking the dtsx and opening it in, say, Notepad++, then moving down to the DTS:ConnectionManager with the "ObjectName" for your connection in the package, and looking at DTS:Property Expression DTS:Name="ConnectionString" tag?
You'll note that this section doesn't have a default value that you'd usually load into the window when you build the object. Here's an example from one of my packages that uses expressions for the packages (I use configurations heavily).
<DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property><DTS:PropertyExpression DTS:Name="ConnectionString">@[User::FilePath] + @[User::ClientFileName]</DTS:PropertyExpression><DTS:ObjectData><DTS:ConnectionManager>
However, for the one I'm looking at, if I scroll down a ways into the FlatFileColumn information, I find:
<DTS:Property DTS:Name="ConnectionString">\\SomeServer\Software Deployments\Stage\Dev\SSIS Jobs\SomeClient\Clients_</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
I don't recommend working against the XML in the dtsx, personally, unless you're just trying to explore and see what's under the hood. Use Visual Studio.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]