October 19, 2007 at 9:12 am
Hey,
I just moved from 2000 to 2005 and I find it a bit confusing.
Can someone tell me where to find and create dts packages.
All I have been able to discover is importing a package, but how can I import a package if I am not able to create one first...?
I appreciate it..
October 19, 2007 at 9:21 am
Jay,
DTS is replaced in SQL 2005 by SQL Server Integration Services (SSIS) which is not so tightly coupled with SQL Server Management Studio as DTS is with Enterprise Manager.
The most common way to create an SSIS package is with the Business Intelligence Development Studio (BIDS). To muddy the water even more, legacy DTS packages can be stored and executed in SQL 2005 if you have the SQL Server 2000 DTS Designer components installed.
I've had a pretty steep learning curve in SSIS, even though I have a lot of DTS experience, so I think it's worth you time to get a SSIS book and read some articles.
Greg
Greg
October 19, 2007 at 9:40 am
I recommend Professional SQL Server 2005 Integration Services published by Wrox.
October 19, 2007 at 10:02 am
There is a DTS Runtime environment in SQL Server 2005 that can let you continue to run old DTS packages. For new ones, you'd be better off learning the basics of SSIS.
You can also use the import/export wizards to build a basic SSIS package you can then look at to learn a bit about how it works.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply