August 27, 2008 at 12:36 am
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.
August 27, 2008 at 10:37 am
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
August 27, 2008 at 10:57 am
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
August 27, 2008 at 2:54 pm
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.
August 27, 2008 at 11:14 pm
Am in management studio.
August 28, 2008 at 9:19 am
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