It is the delimiter that I am having trouble with. For example and address that has a comma in it. Before I could force DTS to see say...

I have specified a , but it won't let me specify anything else. I believe that the OLAP connection is overriding. But there is the source and then...

PD,

Thank you so much - That really helps. I was googling every combination I can think of but you have the answer.

Thanks again - I am going to...

PD,

One more question - Why wouldn't parameter mapping be used?

Phil

PD,

Thank you so much. It did work. Now I can take this veriable and use it in another Execute SQL Task? This is how my Old DTS...

First,

I just wanted to thank you all for your responses.  I really appreciate it.  It eases my stress knowing there is help out there.

I tried the Active X and it...

Bill,

(sent email also)

I was searching for solutions to a problem I have.  I need to pass a variable from a table from SQL server to a bat file.  I see...

Steve,

Excellent my ozzy friend.  Perfect example. This is exactly what I was looking for.  Global Warming is going to get us.  Hear the drought is pretty bad.  I am in...