Re: DTS Package Connection Properties Access Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry for the terminology confusion. When a DTS package is designed the GUI
shows Connection 1 as the source node, Connection 2 as the destination node
and an arrow or bar representing the transformation or flow of the data. I
can click on Connections 1 and 2 and see the properties of the source and
also the destination of the exported file. The problem occurs when I right
click on the transformation to view the properties or the SQL syntax and
transformation characteristics. That's when the error pops up. If I design
the same DTS package from scratch, I do not get the error. If I remote
desktop into the server, I don't get the error.
Thanks for all the time.
--
Stan Gosselin


"Allan Mitchell" wrote:

Hello Stan,
Then it is looking for a server connection that is not visible from your
PC or if you have used different logins to log on between the server and
your PC and the connections are using Trusted Authenitcation then you are
not wuthenticated.

What is the connections bar?

Allan


Alan,
I am trying to acces the Connection properties from my PC within
Enterprise
Manager. I right-click on the DTS Package, select Design and that
brings up
the GUI design form. I right-click on the Connection bar, select
Properties
and get that error. I do not get, that error on the source or
destination
node.
If I physically go to the server itself to do this, I do not get the
error.
"Allan Mitchell" wrote:

Hello Stan,

So where are you accessing the properties?

It sounds as though there is a reference to a server that the package
cannot now find.

Allan

We have migrated a SQL Server based system to a new server. Along
with that,
we copied over some very simple DTS packages. They each export data
to .txt
files. When I click on the packages to view the design, I can click
and see
properties for the Source and Destination nodes but when I try to
click and
access properties for the Connection, I get this error window:
Package Error:
Error source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB][ConnectionOpen (Connect()).] SQL
Server does
not exist or access denied.
Note: This problem does not occur when accessing these packages
while
on
the Server and it does not occur when I design a new package
myself.
Only
from my desktop on my PC. I cannot find anything else in Enterprise
Mgr for
this group that I cannot access. I hope this is stated clearly.
Thanks for any help.



.

Relevant Pages

  • Re: import 100+ tables from ACCESS to SQL Server w/ same structure
    ... Linked server needs to be pre-created and it is inflexible to change. ... DTS package is more flexible. ... Dim oTask ... The DTS should make the connection configuration flexible so ...
    (microsoft.public.sqlserver.dts)
  • Re: events not fired on the non-development machine
    ... Can it be that my design is completely wrong? ... > good design to implement connection points in this case (don't ask me why ... server to it. ... the terms "client" and "server" are used too ...
    (microsoft.public.vc.atl)
  • Re: setup an offline connection
    ... If you are calling the package in VB then you can simply use the object ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > the laptop to a client, I would like to modify the DTS package to ... > delete the connection to my computer and put the connection to their ...
    (microsoft.public.sqlserver.dts)
  • Re: Find My InstanceName in DTS Activex Script
    ... That is connection information inside the package. ... A connection can point to a server that is not the one from which it is retrieved. ... server from which to retrieve the package you also send to the ...
    (microsoft.public.sqlserver.dts)
  • Re: Connection Failure
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I built a package on my development server. ... I copied the backup to my production server & transfered ... > I opened the package an selected each Connection. ...
    (microsoft.public.sqlserver.dts)