Well, the problem was solved by changing the passwords again. There must have been a breakdown between the servers and what PW they were using.

Whew! We are good until Corporate...

Thanks! I was trying to be lazy and use the tools provided by SQL Server, oh well...

I rewrote the job using a script to decide which type of file it...

I am having Linked Server issues with Oracle too. In my case, I want to copy the complete table from Oracle to SQL Server 2005. It gives me an...

Amazing! I KNEW Will's answere would not work, come on, just rename a file? But it really worked! Thanks Will!

For my own edification, and because is seems more "professional", I...

I think I am having the same problem. I can run the FTP task from my workstation, but not from the server. I even can run it through Integration Services,...

For an unsolicited comment...

I DO have your book (purchased), and I have to say that it is one of the best books I have ever gotten to get you up...

Thank you! That was the trick.

I wrote a lot in VB 6, Now I am using Access 2003. They are VERY similar. VB 6 was much more powerful, with a lot more obscure commands. If...

Jonathan is correct. Do you have the connection set to the Excel connection object?

I bow to your superb intellect! Thank you! It worked!

Can you change the process? How about when the FTP if finished in the script to rename the files, then have the DTS project look for the new name?

I know Phil provided an answer, but just to beat a dead horse, there is one more query,

SELECT & FROM TableA WHERE RTRIM(col5)=''

will pick up if col5 has only...

I think I am a little confused. Do you want to know what the difference between the two dates is in months?

DATEDIFF(month, [startdate], [enddate]) will give you the difference...

Agreed. I was just addressing the mapped drive mis-information. Abdul should check permissions, although the error does not seem to indicate that problem.

I would say that almost 100% of the...

Mapped drives only work when a user is logged in to the system (server, workstation, whatever). DTS runs under the SQL Server Agent SERVICE, which does not use any logged...