Connection Reading XML Config File

I have setup a XML Configuration file that contains my connection string

for my DB connections. My package has 2 exec SQL tasks and the a data flow task that use the sam connections. The 2 exec tasks work perfectly and I can see that they did what they were supposed to do. The problem is that when I get to the dataflow task it get login failed even though it is using the same connection from the connection collection. I even tried to delete the OLE DB input to the data flow and add it back but it will not even let me parse the query. Any help would be apprciated.

[584 byte] By [Phil026] at [2007-12-19]

SQL Server

Site Classified