2005 dts package question

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.
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
<Paul@.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.
|||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" <Paul@.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.
|||Ok thanks for the information, will take a look at it.
Paul G
Software engineer.
"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
> <Paul@.discussions.microsoft.com> wrote:
>
>
|||ok thanks for the information. I like the way the DTS packages can be easily
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
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" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
>
|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"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" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
|||<quote>
Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
</quote>
You can actually still do this. (Took me a little while to find it.)
You just need to right click on the database name and then select Tasks.
Import and Export are options under that. There is also an option to
save the SSIS package.
Hope this helps,
Matt
*** Sent via Developersdex http://www.codecomments.com ***