It's working just fine for me if I run it from DOS cmd promt.

What's wrong to my SQL code?

here is the error that I get if I call the .bat...

Windows authentication

is that an issue?

This excel file is the file I created, so I have access to it.  I tried to copy the whole path and past it to my browser to open the file and...

Hey ????,

thanks for your reply.  What I am trying to do is to extract data from a table that resides on a different server (called server B)than the server  (called...

Thanks...

I've found the cause for the first error... it should have been ON instead of WHERE.

Well, I have few DTS packages saved on the SQL server to generate daily reports. Once those daily reports are no longer needed, I want to save those DTS packages...

Thanks!  It works great...

Thank you Jim for your help.  However, I think I did not express correctly what I wanted to do.  Actually, what I wanted to do was to copy one file from my...

Is there anyway we can get the time a scheduled DTS package run too?

Thanks for your help!