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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-01-12 : 15:38:34
|
| I have the Business Intelligent Project but inside I don't have Data Transformation Project Template.I have:* Analisys Services Project* Integration Services Project * Report Model Project * Import Analisys Services 9.0 Database * Report Server Project Wizard * Report Server ProjectLike the question, I don't have the Data Transformation Project Template and I have SQL Server 2005 Client Tools instaled.Maybe I have to have something else instaled.... what?Note: I am using Developer edition.. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-12 : 15:52:38
|
| DTS was renamed to Integration Services in 2005, so the template you need to select is Integration Services Project. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-12 : 15:52:42
|
| DTS is now Integration Services in SQL Server 2005.Tara Kizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-12 : 15:53:00
|
 Tara Kizer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-12 : 15:54:58
|
| DTS is obselete in SQL Server 2005. It is now called SSIS (SQL Server Integration Services).However, SQL Server 2005 is able to run old DTS packages if you download the SQL Server 2005 Feature Pack.You can even edit old packages with the tools in this Fetaure Pack.Peter LarssonHelsingborg, Sweden |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-01-12 : 15:57:05
|
| Thanks for all of ur replies! but may i know what is the differnce in DAta transformation services in management studio and BI |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-01-12 : 15:58:16
|
| Okay thanks i got it from PESO's answer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
DTS IN 2K5