Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
starnold
Yak Posting Veteran
83 Posts |
 Posted - 2008-10-15 : 11:50:48
|
| How can you create a DTS in 2005 or has it been replaced with something new? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-15 : 11:52:00
|
It's been replaces with SSIS.However you can run your old DTS packages without converting them into SSIS.Just install SQL Server 2005 compatibility pack.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
starnold
Yak Posting Veteran
83 Posts |
Posted - 2008-10-15 : 11:55:06
|
| I need to create a new one so will start with SSIS, where can you find it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-15 : 12:48:28
|
quote:
Originally posted by starnold
I need to create a new one so will start with SSIS, where can you find it?
You can create SSIS packages from SQL Business Intelligence Development Studio (BIDS). You need to install it while installing SQL Server (select reporting services,integration services, analysis services option). Inside BIDS, you need to start an integration services project and then it will provide you with blank SSIS package. |
|
|
|
|
|
|
DTS in SQL 2005?