Re: DTS and MSDE

Hi Alllan,

Once again, thx. for the help. I really appreciate it. I think I found the
solution to my problem, which happens to be an error on my part. It turns out
the dts pkg's were using winnt authentication rather than sql server, so the
connection error. All seems to be well, now.

sorry about that.

jim
"Allan Mitchell" wrote:

Hello Jim,

To use DTSRun you have to have at least the runtime installed on the box
that does the calling of the package as the package runs from the place calling
it and not on its storage location.

I will presume that the package is stored on a SQL Server somewhere.

The error may not be from the retrieval of the package from storage but from
a connection internally.

What account are things running under?

You can trace the storage server to see if the attempt gets made to retrieve
from the storage there.




--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Hi Allan,

I'm not sure I follow you about the runtine w/ MSDE 1.0. The packages
are running per the dtsrun utility (command prompt). I have one pkg
that does not have any global variables. The remaining do. However, I
receive the following error msg:

Error #: -2147467259
Error Desc: [DBNETLIB][ConnectionOpen(Connect()] SQL Server does not
exist
or access denied
Error Source: Microsoft OLE DB Provider for SQL Server.
The above error is not appearing the in the vb app (removed error
handling). Also, the odd thing about this error is, I'm able to run
the stored procedures in the dts pkg's via osql.exe w/ no problem.
That is, e.g. osql -S <username> -P <password> -d <DBName> -q "EXEC
Get_MyData @parm1='something'". The data is returned w/ no Connection
problem. I do the same w/ dtsrun /S <username> /P <password> -N
<pkgname>.

The pkg's w/ the global variables can't be executed properly because I
can't the use /A switch.

I've even used the "sa" login to execute the dts pkg and still
receiving connection error.

any help is appreciated.

jim
"Allan Mitchell" wrote:
Hello Jim,

So you are using SQL Server 7?

Only the runtime is installed with MSDE 7. How do you know the
package runs or think it runs?

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
|
http://www.konesans.com
Hello,

I have vb (6.0) app that attempts to execute a couple of dts
packages. The pkg's merely does some data retrieval and pumps the
data into a text file (.dat). The app runs fine on the machine that
have sql server (7.0) installed. However, on the machine w/ MSDE the
app appears to be executing the pkg but the text file is not being
created or the data is not being stored into file.

Not sure why this is happening.

any help is appreciated.




.

Relevant Pages

  • Re: Auditing SP Execute.
    ... > As long as the users only have execute permissions on the proc i.e. they ... This assumes that the app doesn't use a single ... > Jasper Smith (SQL Server MVP) ... >> particular sp was execute and by whom. ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: ETL rejects records intermittently
    ... The data source is the SQL SERVER 2005 table. ... We first dump the data from ... When I execute the SSIS package ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >execute rather than just assigning its sql statement and execute it later.I need the result in my Activex Script. ... > 'EXIT from function if there is another instance of the same package is running ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Text File Fails from Server Box
    ... If you are on WKSTN1 and you pick up a package from SVR1 and press execute, ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I should have specified in my question that in re-creating the text> connection, I did point in to a file local to the SQL Server. ... When I click on the>>> Destination tab, there is an execute button. ...
    (microsoft.public.sqlserver.dts)