D'Arcy from Winnipeg
Musings of a Canadian web developer

SQL 2005 DTS Project?

Saturday, January 21, 2006 10:24 AM

Looking for some help here...

I'm want to play around with the dts project within the SQL 2005 BI Dev Studio, but I don't see the DTS project listed as an option.

Am I missing something? Did they move it from the beta?

To take it a step further, I have a SQL 2005 database, and I want to take a snapshot of some tables and dump them into a SQL Mobile database (.sdf) file....just in case anyone has experience with that.

;)

D


Feedback

# re: SQL 2005 DTS Project?

DTS is now called SQL Integration Services. Open Visual Studio 2005, select Business Intelligence Projects from the New Project dialog, and create a new Integration Services Project.

1/22/2006 6:35 PM | Mike

# re: SQL 2005 DTS Project?

Had the same question and couldn't find the solution in Books Online (which I don't like at all... Google rules! :) ).
Thanks! 8/2/2007 1:55 AM | Joris

# re: SQL 2005 DTS Project?

the interface in the beta seemed a lot simpler, dont like the new project format, it has too many options 10/9/2007 12:47 AM | money blogs

# re: SQL 2005 DTS Project?

Hi ,

I am new to itnegrated services. could you please elaborate on how to use it. We have a remote database with remote access to our server. what is the best way to export records from local database?

regards,
Hiren 12/11/2007 3:29 PM | web design melbourne

# re: SQL 2005 DTS Project?

Thanks. nice idea 6/2/2008 12:56 AM | ric

Post a comment





 

Please add 2 and 5 and type the answer here: