|
|
Posted by DickChristoph on 05/05/06 13:31
Hi Brian
Can you open the package and look at the connections. Dan was suggesting
that one of these connections might be "(local)". also I would add to my
previous comment, the username specified for these connections might lack
the privileges to connect to the database.
Also if to open the package and execute it from the designer you can see
which step is crashing.
--
-Dick Christoph
"Brian Peasland" <oracle_dba@nospam.peasland.net> wrote in message
news:Iyrtp9.25D@igsrsparc2.er.usgs.gov...
> Dan Guzman wrote:
>> To add to Dick's response, be aware that the DTS package runs on same
>> machine as DTSRUN. You'll get these errors if you run the package on a
>> client machine and have specified SQL Server name 'local' in the DTS
>> connection.
>>
>
> I do plan on running the DTSRUN utility from a client machine, but I have
> stated the SQL Server's name in the /S switch. I did not use 'local' or
> '.' for the server name since I know the package is not local to the
> client.
>
> Thanks,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba@nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Navigation:
[Reply to this message]
|