Kent, have you ruled out security access issues for the file on the hp?
Raymond Shahan
Information Systems
REPUBLIC TITLE OF TEXAS, INC.
2701 W Plano Parkway
Plano, TX 75075
direct 214.556.0202
main 972.578.8611
fax 972.424.5621
www.republictitle.com
[log in to unmask]
Life is not a journey to the grave with the
intention of arriving safely in a pretty and
well preserved body, but rather to skid in
broadside, thoroughly used up, totally worn out,
and loudly proclaiming:
-- WOW!!! What a Ride!!!
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Kent Wallace
Sent: Monday, December 10, 2007 10:50 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] SiSS package FTP task to HP3000
I am trying to use .Net 2005 with SQL 2005 and use Integrated Services.
There is a control flow item called FTP Task. It is a FTP GUI toolbox
object.
I can set up the connection object and test the connection to the
HP3000. However no matter what format of the file I try I get a non
existent file.
I tried:
/ADANTA/PUB/PDC003RP
/PDC003RP
PDC003RP {when I tried this it said I needed A '/')
I do not know the syntax for FTP to find the file.
SSIS package "Package.dtsx" starting.
Error: 0xC0029183 at FTP Task, FTP Task: File represented by "/PDC003RP"
does not exist.
Task failed: FTP Task
Warning: 0x80019002 at Package: SSIS Warning Code
DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the
number of errors raised (1) reached the maximum allowed (1); resulting
in failure. This occurs when the number of errors reaches the number
specified in MaximumErrorCount. Change the MaximumErrorCount or fix the
errors.
SSIS package "Package.dtsx" finished: Failure.
This is on the HP30000
PUB.ADVANTA:listf pdc003rp,2
ACCOUNT= ADVANTA GROUP= PUB
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
PDC003RP 644 518B FA 9239 99999 15 22528 14 32
PUB.ADVANTA:
Thanks
Kent
-----Original Message-----
From: [log in to unmask] [mailto:[log in to unmask]]
Sent: Monday, December 10, 2007 9:37 AM
To: Kent Wallace
Subject: Re: SiSS package FTP task to HP3000
On Dec 6, 6:58 pm, Kent Wallace <[log in to unmask]> wrote:
> This is on topic. Has anyone put the Remotepath in right? I keep
> getting a non exit file.
>
> Thanks
>
> Kent
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visithttp://raven.utc.edu/archives/hp3000-l.html*
Kent,
Good morning it's Jason, we have spoken in the past. Can you please
elaborate a bit on your request. I assume you are trying to setup the
HP as the remote path in SSiS?
Please let me know
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
