Options in tool box for creating packages in SQL Server 2005

  • 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.

  • 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

  • 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

  • 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.

  • Am in management studio.

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply