Showing posts with label icon. Show all posts
Showing posts with label icon. Show all posts

Friday, March 9, 2012

How to create a DTS package in SQL 2005?

How Do I create a package in SQL Server2005? I have the eval copy. I saw an icon for DTS in Management Studio but when right click there is no option for New.

SSIS is the way to go in SQL 2005. DTS is pretty much phased out in SQL 2005, and but is supported for backward compatibility. See topic "Upgrading or Migrating Data Transformation Services" for more information.

Wednesday, March 7, 2012

How to crearte database in MSDE

Ihave installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .

Please help me in this.Answered here:http://forums.asp.net/1062587/ShowPost.aspx#1062587