look at this one :

http://msdn2.microsoft.com/en-us/library/ms143241(SQL.90).aspx

it has something to do with the fact that SQL 7.0 doesn't know what the management studio is.

Look in that direction i would say.

Good luck

yes, two early for 64bit it seems. Having some troubles too. Replication is also an issue.

We also tried to use the dtexec 32bit, but even that doens't work. Now we...

Hi

We have had some same issues and still have. We have another problem. We are running sql server on a 64bit machine but it seems that the dtexec used for...

Hi

Thanx. It's not my table design 🙂 It's from an ERP system.

I will give it a shot

Hi sorry but no habla Espanol

Like the country though 🙂

Becoz whe have the same issue using a job.

Can this be an issue becoz we are using the 64bit version and mdac is only 32bit ?

I've had the same issue. Couldn't solve it. Working with dts now. Small tables.

Replication from 2005 to 2000 is not a problem.

Error was that Management studio is needed in sql...

thx

will give it a shot

Hi Joseph

We need it for replication between data through firewall.

Can it be done by DNS ? If yes, can you show me the light ?

Thx in advance.

too quick to ask.

Already solved it. Just learning that mighty 2005 🙂

Detail :

The servers are from a different domain.

I'm not used to work in the command line, sorry

How do u do it in a command line ?

thx in advance

El Jefe

The problem was something different.

Ftp site i need is like http://ftp.downloads.co/downloads.

In SQL u can only use http://ftp.downloads.co

That /downloads is the problem. But I need, so now i have...