Options in tool box for creating packages in SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Options in tool box for creating packages in...

Options in tool box for creating packages in SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Joy Smith San

Posted Wednesday, August 27, 2008 12:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:13 AM
Points: 1,371, Visits: 2,299

Dear All,
Am trying to make a new package in SQL Server 2005.
In the tool box am not able to see Data Flow Task, Connection etc, Infact am seeing very few options like 'Backup database Task', 'Shrink Database Task' etc. Where can I find the other options..?

Thanks...

Santhosh Nair.

Post #559366

GSquared

Posted Wednesday, August 27, 2008 10:37 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

Are you in Management Studio or Business Intelligence Development Studio?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #559797

Greg Charles

Posted Wednesday, August 27, 2008 10:57 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 4,007, Visits: 4,851

nairsanthu1977,

What you're seeing are the tasks available for a maintenance plan package. You have to use BIDS to create any other SSIS package.

Greg

Post #559817

Jeremy Brown

Posted Wednesday, August 27, 2008 2:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:07 AM
Points: 190, Visits: 244

SQL Server 2005 has totally replaced DTS with SSIS. I suggest grabbing a couple "learn in 24 hours" books or go grab Brian Knight's wonderbook of SSIS god power.

Post #559963

Joy Smith San

Posted Wednesday, August 27, 2008 11:14 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:13 AM
Points: 1,371, Visits: 2,299

Am in management studio.

Post #560121

GSquared

Posted Thursday, August 28, 2008 9:19 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

You have to go to BIDS to build SSIS packages, except maintenance plans. That's why you're seeing the maintenance plan options, but not anything else.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #560585

« Prev Topic | Next Topic »

Permissions