Help batch script task stuck in a loop

I have a .bat file that calls a script file to log in to a server and upload a file to my pub account. When I run the .bat file it just executes the command over and over and never executes the script file. Does anyone know why? Am I missing something in my script or .bat file commands below?

my .bat file contains this>ftp -s:script.txt

my script file contains this:

open myserver.com
username
password
put W:\UPLOAD\doc.txt
bye
exit

Thanks,

Mike

Looping doesn't seem reminiscent of the batch file or the script you have listed here. I sounds like it may be due to some logic in your package. Any chance this is happening in your package?|||

It works now.

|||

Mike,

I have the same problem, can you post the solution?

Thanks.

Sebastian.

|||

Instead of using the batch file, I used a ftp script and called it using the Execute Process Task Editor:

Executable: C:\WINDOWS\system32\ftp.exe

Arguments: -s:"C:\Documents and Settings\me\Desktop\SQL 2005 DMS project-Prod\Download E-Apps\ftpscript.txt"

the ftpscript.txt file contains the following:

open hostname
me
password
Ascii
put filepath\name
bye
exit

sql

Help batch script task stuck in a loop

I have a .bat file that calls a script file to log in to a server and upload a file to my pub account. When I run the .bat file it just executes the command over and over and never executes the script file. Does anyone know why? Am I missing something in my script or .bat file commands below?

my .bat file contains this>ftp -s:script.txt

my script file contains this:

open myserver.com
username
password
put W:\UPLOAD\doc.txt
bye
exit

Thanks,

Mike

Looping doesn't seem reminiscent of the batch file or the script you have listed here. I sounds like it may be due to some logic in your package. Any chance this is happening in your package?|||

It works now.

|||

Mike,

I have the same problem, can you post the solution?

Thanks.

Sebastian.

|||

Instead of using the batch file, I used a ftp script and called it using the Execute Process Task Editor:

Executable: C:\WINDOWS\system32\ftp.exe

Arguments: -s:"C:\Documents and Settings\me\Desktop\SQL 2005 DMS project-Prod\Download E-Apps\ftpscript.txt"

the ftpscript.txt file contains the following:

open hostname
me
password
Ascii
put filepath\name
bye
exit

HELP !Please . Urgent

after i done the replication from sql server 7.0(pub/dist) with sql server
2000(subscription) there will promt out the error like below :
Agents Last Action
Snapshot No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
Log Reader No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
202.168.xx:XXXXX No such interface supported.NOTE:The step was retried the
requested number of times(10)without succeeding.
The step failed.
ALL ERROR!!!!!
Please help...
thanks a lot
Sam,
are you doing merge replication by any chance - this configuration is not
supported.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It sounds like your com components did not get registered. Did you apply an
sp recently? If so you should reapply it.
If not, is this relevant?
http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/6252b9649b296145
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sam@.discussions.microsoft.com> wrote in message
news:F09CBB95-050E-4704-AEB0-4C8B0AE77809@.microsoft.com...
> after i done the replication from sql server 7.0(pub/dist) with sql server
> 2000(subscription) there will promt out the error like below :
> Agents Last Action
> Snapshot No such interface supported.NOTE:The step was
> retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> Log Reader No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> 202.168.xx:XXXXX No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> ALL ERROR!!!!!
> Please help...
> thanks a lot
>
|||I doing transactional replication.
Thanks for your replied.
"Paul Ibison" wrote:

> Sam,
> are you doing merge replication by any chance - this configuration is not
> supported.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - please see if this applies:
[url]http://groups.google.co.uk/group/microsoft.public.sqlserver.replication/browse_thread/thread/bdd1dfac50797c18/190e2af45971b1cb?lnk=st&q=No+such+interface+suppor ted+sql+server+replication&rnum=1&hl=en#190e2af459 71b1cb[/url]
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .