>Hi I am working with the trial ms2005 SQL Server measurement studio.  I could
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000.  JUst wondering if someone could point me
>in the right direction, thanks.

"Sue Hoegemeier" wrote:

> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
>
> -Sue
>
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <P***@discussions.microsoft.com> wrote:
>
> >Hi I am working with the trial ms2005 SQL Server measurement studio.  I could
> >not find how to create and schedule a DTS package, guess this is done with
> >Enterprise Manager with mssql2000.  JUst wondering if someone could point me
> >in the right direction, thanks.
>
>

"Paul" <P***@discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio.  I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000.  JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.

"d" wrote:

> they destroyed DTS. and replaced it with a very complicated software called
> Integration Services.
>
> Just so you know, you had 4 steps to create an import from a text file. now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
>
> d.
> "Paul" <P***@discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@microsoft.com...
> > Hi I am working with the trial ms2005 SQL Server measurement studio.  I
> could
> > not find how to create and schedule a DTS package, guess this is done with
> > Enterprise Manager with mssql2000.  JUst wondering if someone could point
> me
> > in the right direction, thanks.
> > --
> > Paul G
> > Software engineer.
>
>
>

"d" <d@d.com> wrote in message news:kAZSf.1312$I7.999@trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
>
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
>
> d.
> "Paul" <P***@discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@microsoft.com...
>> Hi I am working with the trial ms2005 SQL Server measurement studio.  I
> could
>> not find how to create and schedule a DTS package, guess this is done
>> with
>> Enterprise Manager with mssql2000.  JUst wondering if someone could point
> me
>> in the right direction, thanks.
>> --
>> Paul G
>> Software engineer.
>
>