Re: DTS and MSDE

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: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • ADO.NET 2.0 & MSDE & Win98
    ... Framework 2.0 which must be deployed on Windows 98 platform. ... The MSDE will ... be installed on Win98 as the SQL Server to which the app will connect. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Linked MSDE tables in Access
    ... is very little concurrency (it's an accounting app). ... > that is, aspx pages. ... > difficulty to have the ASP.NET app directly talk to SQL Server. ... >> MSDE tables. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: programmatically DTS something to a SQL Server instance
    ... Scheduler to run the package. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > "look into MSDE and how to programmatically DTS something to a SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net/sql server speed issue
    ... A lot depends on how the app is used. ... > dataadapter hit the database build a dataset and drop the connection.... ... >> MSDE is the same engine as SQL Server but it has 2 major limitations. ...
    (microsoft.public.dotnet.framework.adonet)