dbTalk Databases Forums  

looking for the dts template in 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss looking for the dts template in 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
WebBuilder451
 
Posts: n/a

Default looking for the dts template in 2005 - 06-27-2006 , 09:12 AM






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

Reply With Quote
  #2  
Old   
Matt
 
Posts: n/a

Default RE: looking for the dts template in 2005 - 06-27-2006 , 08:29 PM






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:

Quote:
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

Reply With Quote
  #3  
Old   
WebBuilder451
 
Posts: n/a

Default RE: looking for the dts template in 2005 - 06-28-2006 , 08:43 AM



thank you, I was using an older version of a ms press book, that i'd guess
came out when 2005 was still in beta
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes


"Matt" wrote:

Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.