Good thought. When I manually type it it works fine. What I am doing is calling this bat file in SQL SERVER. I created a DTS package and the package runs the bat file. When I execute the package it runs fine. When I schedule the package, it uses a SQLSERVERAGENT account to run the package, that is when it fails, so I was thinking by imbedding the connection and username and password intot he bat it might work, but thinking loudly about it now, I don't think so.
I have to find another way