MSDE and DTS packages

From: whiggins (anonymous_at_discussions.microsoft.com)
Date: 04/24/04 

Date: Fri, 23 Apr 2004 18:56:03 -0700

Hi all
I am new to the msde and have worked with SQL for a little while. I have developed my database on my SQL server and now have transfered it to MSDE with only one problem.

I have exported the dts package to a text file, but when I import it into MSDE there is nothing there.

My question is can I (and how) create a DTS package through vbscript or osql? I have looked in MSDN and found the dtswiz with command line switchs, but I can not find an example using a text file. I unbderstand that there are a few more switches to tell it the delimitation.

Any help would be very appreciated.

Thanks for your help in advance.

Relevant Pages

  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: msde2000
    ... MSDE is the desktop version of SQL server. ... Basically, Access is a desktop application, MSDE is a database backend. ... go through OLEDB, so theoretically therefore it's arguably the fastest ...
    (microsoft.public.vc.language)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)