November 20, 2012 at 11:54 am
I am confused. I hope someone can give me some direction.
From the old sql 2000 we used to create DTS packages. Now they are called SSIS packages.
What does the developer need to be able to create these SSIS packages. I am able to create it on the server side but not every developer has rights to the server.
What do I need to install on the developer's workstation if they want to manage their own SSIS packages. SQL or Visual Studio?
Thank you in advance for clarifying this frustation.
November 20, 2012 at 12:10 pm
They need Business Intelligence Development Studio (usually called BIDS). You can install that from the SQL Server installation disk, just choose the Client Tools option when asked what to install, and pick BIDS as the piece to install.
- 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
November 20, 2012 at 12:19 pm
Thank you. I will try it out. Just trying to recap. BIDS comes from SQL Server program and not from Visual Studio?
Is it also the same for SQL 2005, SQL 2008 and SQL 2012?
November 21, 2012 at 7:55 am
BIDS is an extension of Visual Studio, so Pro Edition VS might have what you need. I'm not sure about that.
BIDS is not the same in 2005, 2008, 2012. You actually need different copies of BIDS to build for each. Can't use BIDS 2008 to build SSIS packages for SQL 2005 or SQL 2012, for example. Very dumb implementation on Microsoft's part. Should have a "deploy to version" option that can deploy to prior versions, at the very least, but they don't.
- 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
November 22, 2012 at 7:41 am
Can we download BIDS for sql server 2008 r2 online ? If yes can you provide tle links?
Thanks
November 22, 2012 at 7:49 am
kenzomus (11/22/2012)
Can we download BIDS for sql server 2008 r2 online ?
No, it's part of the SQL Server installation. Run the SQL Server installation on their machine and just select the client tools (and I suggest documentation) from the list.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply