![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
ok simple question and maybe i don't even need the template. How do you create a new dts package in 2005 Note: I have VS2005 pro as well as sql 2005 when i goto Sql server business intelegence studio VS pro starts but no DTS (Data Transformation Project) template -- thanks (as always) some day i''m gona pay this forum back for all the help i''m getting kes |
#3
| |||
| |||
|
|
DTS has been replaced by SQL Server Integration Services in 2005. To create an SSIS package you'll need to open the Business Intelligence Development Studio. From the BI dev studio, click "New Project" and select "Integration Services Project" from the "Business Intelligence Projects" project type. This will allow you create transformations similar to those that were created in DTS in SQL Server 2000. "WebBuilder451" wrote: ok simple question and maybe i don't even need the template. How do you create a new dts package in 2005 Note: I have VS2005 pro as well as sql 2005 when i goto Sql server business intelegence studio VS pro starts but no DTS (Data Transformation Project) template -- thanks (as always) some day i''m gona pay this forum back for all the help i''m getting kes |
![]() |
| Thread Tools | |
| Display Modes | |
| |