Re: MSDE and DTS packages

From: Ranjeet (ranjeetathwal_at_hotmail.com.nospam)
Date: 05/05/04 

Date: Wed, 5 May 2004 14:10:39 +0100

I'm guessing you want to import dts packages into MSDE (if not my
appologies).

you can save the package as a structured storage file and use a little vb
app to load the package in memory and then save it to the msde using
SaveToSQLServer function of the package class ?

If you have a SQL Server then you can also use enterprise manager to simply
save the DTS packes directly to your msde instance.

Hope this helps.

Ranjeet.

"whiggins" <anonymous@discussions.microsoft.com> wrote in message
news:8A03C082-9B78-4106-83EF-F2DC7FBD65E6@microsoft.com...
> 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: can MSDE import DBF files?
    ... more info about the different editions of SQL Server. ... I install SBS for clients and know who long it ... > takes to install and patch, so I thought I'd try MSDE on my local PC. ... >> You could create a DTS package to solve the problem, ...
    (microsoft.public.sqlserver.msde)
  • Re: DTS error -21472887 (80040E21)
    ... Please do not post the same question independently to multiple newsgroups. ... Please see my reply in .msde ... can be cut and pasted into Query Analyzer is appreciated. ... > Trying to run a DTS package from a stored procedure using xp_cmdshell but ...
    (microsoft.public.sqlserver.security)
  • RE: sql vs excel
    ... "Mike Epprecht (SQL MVP)" wrote: ... > You can create a DTS package in SQL server and then have MSDE run it. ...
    (microsoft.public.sqlserver.programming)
  • RE: sql vs excel
    ... You can create a DTS package in SQL server and then have MSDE run it. ... "Nikolami" wrote: ... > if I insert recordset into database, depends on datetime, other record will ...
    (microsoft.public.sqlserver.programming)
  • MSDE and DTS packages
    ... 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. ...
    (microsoft.public.sqlserver.msde)