Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Options in tool box for creating packages in SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2008 12:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 1,507, Visits: 2,536
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
Posted Wednesday, August 27, 2008 10:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Wednesday, August 27, 2008 10:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 4,065, Visits: 5,277
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
Posted Wednesday, August 27, 2008 2:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307
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
Posted Wednesday, August 27, 2008 11:14 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 1,507, Visits: 2,536
Am in management studio.
Post #560121
Posted Thursday, August 28, 2008 9:19 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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 »

Add to briefcase

Permissions Expand / Collapse