Re: How do I distribute DTS Packages with my Application Database?

From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 17:26:09 -0500

Thanks Allan,

I see a couple of useful options in that article.

BTW, is there any way to store a DTS package in a specific *database*, as
opposed to being global on the Server? And if not possible with SQL Server
2000, how about with v2005? Or is this something which is just not a good
idea for some reason?

Thanks,

Joe Geretz

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u4Cj4554EHA.2568@TK2MSFTNGP11.phx.gbl...
> Number of ways but undoubtedly the easiest is as a Structured Storage file
> (*.dts)
>
> Have a look here
>
> Transferring DTS Packages
> (http://www.sqldts.com/default.aspx?204)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Joseph Geretz" <jgeretz@nospam.com> wrote in message
> news:eghnjK44EHA.4028@TK2MSFTNGP15.phx.gbl...
>> We have a software application which runs on a SQL Server database. We
>> distribute our blank database as a SQL Server Backup file, but how do I
>> distribute my DTS Packages?
>>
>> Thanks for your advice,
>>
>> - Joe Geretz -
>>
>
>

Relevant Pages

  • Re: Need help with DTS Package Maintenance
    ... You can create DTS packages in VB, ... > source Interbase Database and I make a SQL Server connection to the target ...
    (microsoft.public.sqlserver.dts)
  • RE: Where are my DTS packages
    ... Your DTS packages in your case are most likely stored in the msdb database. ... If you can get a copy of the old msdb database and restore this you will be ... > SQL Server was lost although the DATA was held on another drive. ...
    (microsoft.public.sqlserver.dts)
  • Re: Moving DTS to new server
    ... you can save the DTS packages as "Structures Storage File" and then open ... these files on your new database and save it in the SQL Server. ...
    (microsoft.public.sqlserver.replication)
  • Re: How do I distribute DTS Packages with my Application Database?
    ... Number of ways but undoubtedly the easiest is as a Structured Storage file ... Transferring DTS Packages ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > We have a software application which runs on a SQL Server database. ...
    (microsoft.public.sqlserver.dts)
  • DTS to run other DTSs
    ... I have created 23 DTS packages to transfer data from an other database ... into SQL server. ... Rather than schedule each of these I would like to ...
    (microsoft.public.sqlserver.dts)