<div>
Just checked again, both server and local PC can connect to FTP with the given user acount details!!!
</div>


<div>
I really haven't abandoned it and still have the issue but no one provided a solution.<br />
<br />
Venabili: &nbsp;is there any chance for you or TA admin to hunt for SQL expert in EE to come to my rescue?
</div>


<div>
Please delete this question and refund points. Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
I have set up an FTP task using Enterprise Manager on my local PC. &nbsp;The task is defined on a one of our Database server. &nbsp;When I run package on local machine it works, when I run on the server it fails with &quot;unspecified error&quot; &nbsp;I tested the ftp account access and I can connect fine using ftp command at the command prompt. &nbsp;I am lost now and don't know what to do next to troubleshoot this.<br />
<br />
Any help is appreciated.<br />
<br />
Thanks<br />
H
</div>
</div>


Hi, 
I have set up an FTP task using Enterprise Manager on my local PC.  The task is defined on a one of our Database server.  When I run package on local machine it works, when I run on the server it fails with "unspecified error"  I tested the ftp account access and I can connect fine using ftp command at the command prompt.  I am lost now and don't know what to do next to troubleshoot this.

Any help is appreciated.

Thanks
H

Just checked again, both server and local PC can connect to FTP with the given user acount details!!!

I really haven&#39;t abandoned it and still have the issue but no one provided a solution.

Venabili:  is there any chance for you or TA admin to hunt for SQL expert in EE to come to my rescue?

Please delete this question and refund points. Thanks

FTP task (DTS package) failing on server but works on local

Hi, 
I have set up an FTP task using Enterprise Manager on my local PC.  The task is defined on a one of our Database server.  When I run package on local machine it works, when I run on the server it fails with &quot;unspecified error&quot;  I tested the ftp account access and I can connect fine using ftp command at the command prompt.  I am lost now and don&#39;t know what to do next to troubleshoot this.

Any help is appreciated.

Thanks
H

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.