dbTalk Databases Forums  

DTS & Windows Server 2003

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS & Windows Server 2003 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike
 
Posts: n/a

Default DTS & Windows Server 2003 - 01-29-2004 , 08:37 AM






I'm setting up an FTP Package on windows 2003. Somehow, I
have a quirk going on. When I try to use ftp.exe on
Windows Xp it works fine, but when I use ftp.exe on
Windows Server 2003 then it takes forever to list the
directories and doesn't end up working. When I use that
FTP task in an execute task for my local server it runs
fine, but when I used the same dts package on windows 2003
it doesn't work. Can anyone provide any insight as to
what may be going on. It sounds like Windows 2003 isn't
set up to use ftp, but isn't that enabled from the
installation?



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS & Windows Server 2003 - 01-29-2004 , 08:53 AM






The FTP service is not installed by default on 2003 so maybe that is it?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
I'm setting up an FTP Package on windows 2003. Somehow, I
have a quirk going on. When I try to use ftp.exe on
Windows Xp it works fine, but when I use ftp.exe on
Windows Server 2003 then it takes forever to list the
directories and doesn't end up working. When I use that
FTP task in an execute task for my local server it runs
fine, but when I used the same dts package on windows 2003
it doesn't work. Can anyone provide any insight as to
what may be going on. It sounds like Windows 2003 isn't
set up to use ftp, but isn't that enabled from the
installation?





Reply With Quote
  #3  
Old   
Mike
 
Posts: n/a

Default Re: DTS & Windows Server 2003 - 01-29-2004 , 09:58 AM



I think I'm getting an error on this step:
150 Opening ASCII mode data connection for /bin/ls.

It just stays there then I have to manually close it
Quote:
-----Original Message-----
The FTP service is not installed by default on 2003 so
maybe that is it?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:67e301c3e675$791a3a70$a001280a (AT) phx (DOT) gbl...
I'm setting up an FTP Package on windows 2003.
Somehow, I
have a quirk going on. When I try to use ftp.exe on
Windows Xp it works fine, but when I use ftp.exe on
Windows Server 2003 then it takes forever to list the
directories and doesn't end up working. When I use
that
FTP task in an execute task for my local server it runs
fine, but when I used the same dts package on windows
2003
it doesn't work. Can anyone provide any insight as to
what may be going on. It sounds like Windows 2003 isn't
set up to use ftp, but isn't that enabled from the
installation?




.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.