Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

SSIS development

in http://msdn.microsoft.com/en-us/library/ms173767%28v=SQL.105%29.aspx
it says "Business Intelligence Development Studio is Microsoft Visual Studio 2008"

does that mean there is any practical inter-dependence between SSIS and VS?

2005 SSIS<->2005 VS
2008 SSIS<->2008 VS
2008 R2 SSIS<->2008 VS

for the next release will it be
2011 SSIS<->2011 VS - does this matter to know? or practically, is SSIS development totally independent if VS is installed or not?
SOLUTION
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112
25112

ASKER

>>For the next version of SQL it will be used VS 2010.
have they mentioned it already? how does it practically affect/impact SSIS development?

will developing 2011 SSIS [package require any VS 2010 install on the machine, also?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The future SQL version (DENALI) is available for download. For now is just the Comunity Preciew (CTP)
The final version (RTM) will be announced january 2012

The new SSIS 2012 required VS 2010.
Avatar of 25112

ASKER

so BIDS is always part of Visual Studio? But it is given in the SQL CD, always to make it convenient?

that means you can instsall BIDS without having to install Visual studio. example:
Can you install 2005 BIDS and not install VS 2005
Can you install 2008 or R2 BIDS and not install VS 2008
Can you install Denali BIDS and not install VS 2010
YES!
:-)
BIDS Its a module of Visual Studio and is installed with SQL!

:-)
Avatar of 25112

ASKER

OK.. does BIDS through SQL influence which VS version can be installed or can exist in the machine?

for example, if I have 2008 R2 BIDS (from SQL install, not visual studio install), and also 2005 BIDS (from SQL install, not visual studio install).
then if I want to put VS 2003/5/8/10 on the same machine, will there be any conflicts? (because BIDS is already there)
It's optional the instalation of BIDS through SQL Install.
Why you want multiple versions of VS?!
Regards
Pedro
I (and others I know) have run into issues when BIDS 2008 was installed on the same box that I had BIDS 2005 on.  BIDS 2008 modifies some components that are held in common with BIDS 2005 and then they don't work with BUIDS 2005.

It should also be noted that you cannot develop a package in BIDS 200Y and then deploy it to a SQL Server 200Y instance.  In other words, if the SSIS package is developed in BIDS 2005, it can only be deployed to SQL Server 2005 instances.  If you then open it and buildit in BIDS 2008, a) it can only be deployed to SQL Server 2008 instances and b) it can no longer be built using BIDS 2005 nor can it be deployed to a SQL Server 2005 instance.
Avatar of 25112

ASKER

>>It's optional the instalation of BIDS through SQL Install.
but I just want to confirm that installing BIDS from SQL 2005 first and then the whole of VS2005 won't give any troubles? (or vice versa, if installed VS 2005 first, and then BIDS is installed as part of SQL 2005 complete installation).

>>Why you want multiple versions of VS?!
may not. just trying to determin how it affects all, and which ones are absolutely needed for development
Avatar of 25112

ASKER


>>I (and others I know) have run into issues when BIDS 2008 was installed on the same box that I had BIDS 2005 on.  BIDS 2008 modifies some components that are held in common with BIDS 2005 and then they don't work with BUIDS 2005.

have you got a resolution for that?

if you install 2008 BIDS first and then 2005 BIDS, is it safer and better?
Avatar of 25112

ASKER

>> you cannot develop a package in BIDS 200Y and then deploy it to a SQL Server 200Y instance.

this does not apply to next release, right?BIDS 2010 and a SQL Server 2012(denali)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112

ASKER

>>Yeah . . . I have a virtual desktop for the 2008 development and my physical desktop for the 2005. ;-)
is there any solution if VM is not possible/allowed in this environment?

>>I don't know how you made that leap.
Isn't BIDS 2010 that is going go with SQL 2012 (denali)?
http://social.technet.microsoft.com/wiki/contents/articles/1740.aspx
Avatar of 25112

ASKER

@8080_Diver,

>> BIDS 2008 modifies some components that are held in common with BIDS 2005 and then they don't work with BUIDS 2005.

Has MS admitted this issue- that BIDS 2005 and 2008 cant be happy together on the same machine;if so, i could use to give it to management to re-think the whole scenario.. ? thanks..
From the link you posted:
2.2 BIDS Is Not Supported in Side-By-Side and Upgrade Scenarios
Business Intelligence Development Studio (BIDS) is not supported in the following situations:

•Microsoft SQL Server Code-Named “Denali” CTP1 BIDS is installed on the same server as an earlier release of MS SQL Server BIDS.

•An earlier release of Microsoft SQL Server with BIDS is upgraded to Microsoft SQL Server Code-Named “Denali” CTP1.

Make sure you create and maintain BIDS projects on computers that do not fall into the categories above.


In other words, no, Denali BIDS does not play well with any other versions of BIDS.

As for a non-vm solution to the incompatabilities, the only other sure solution I can think of is to have a second box to work on.  You might be able to use a dual boot boot to handle it but I doubt it.

Has MS admitted this issue . . .
Well, it would seem so . . . after all, there is that post about Denali BIDS. ;-)

I can see some issues for those who are doing Road Warrior work or supporting multiple small business.  One has to deal with the SQL server versions that one's clients have and one cannot necessarily dictate which version that will be.
Avatar of 25112

ASKER

thanks.

do you see such documentation for R2 because that is the version I really need to make my case for:
http://download.microsoft.com/download/E/7/D/E7DED7E4-5059-4E3E-82C5-B28BF3FD0AAC/SQLServer2008R2ReleaseNotes.htm
http://social.technet.microsoft.com/wiki/contents/articles/microsoft-sql-server-2008-r2-sp1-release-notes.aspx

Also, could you summarize what were the laymen terms symptoms you saw when you had BIDS 2005 and also BIDS 2008 in the same machine.
you create in 2005 and then it won't work? (and vice versa?)
Re: The Case For 2008R2
- For openers, once 2008 was released, SQL Server 2005 has at most 5 years from that date before support is suspended.  Since 2008R2 is now out, 2008 has 5 years before support is removed.  As a general rule, if you are going to set up a database, you need to set it up on the most current version currently available.  If you are going to upgrade, then upgrade to the most current available.

- If your organization is on SQL Server 2000, then it should be noted that SQL Server 2008R2 is the last version that will have a ready upgrade path . . . Denali doesn't even know SQL Server 2000 ever existed. ;-)

- If y'all are looking at SQL Server 2008, y'all might as well go to 2008 R2. ;-)

- The new Date, Time, and new DateTime datatypes will make many aspects of life much easier to deal with and queries more efficient because you won't have to constantly be trimming the time portion off of a datetime datatype that has been filled with GETDATE().

- The new goegraphic datatypes and the functions associated with them open up a whole new aspect of using the data in the database.  For instance, if you hhave a web site that is receiving orders or inquiries, you can determine the gegraphic locations of the users and do things like target certain regions/locations/cities/whatever for offers or other special purposes.

- The BI tools available with 2008 R2 are quite impressive and much better than those available with 2005.

Re; Laymen's terms
What I ran into was that I had developed some packages in BIDS 2005.  I then needed to develop a couple for a 2008 database, so I installed BIDS 2008.  That worked out okay for the 2008 SSIS development; however, when I tried to open up my 2005 packages, I got error fatal messages and couldn't get them to open properly.  In fact, at one point, I corrupted one of the packages while trying to get it to open up in BIDS 2005.  In order to revert to BIDS 2005, I had to uninstall BIDS 2008 and then uninstall what I could of BIDS 2005.  Then I had to search out the various bits that didn't uninstall correctly for both of those.  I was finally able to re-install BIDS 2005.  (Being a persistent and stubborn cuss, I went through this cycle 3 times trying to work out a way to get both on on box. ;-)

Avatar of 25112

ASKER

Thanks for your explanation.. i agree R2 is the best and way to go, if at all possible with the management policies...

*could you provide any msdn link that 2008 R2 components share the same with 2005 (and hence the problems)

the Denali link is good, knowing some here, i know that some may say that is only for future versions..
I don't have a link to the shared component list . . . it is kind of one of those "oops, that borke! :-/ " things.

Avatar of 25112

ASKER

OK.. no problem.. thanks for trying..

could you help with the below:
1)
is BIDS the only point of conflict in the Visual Studio family? Do any other tools clash like this? If VS 2005 and 2008 are on the same machine, are there are any issues like this (other than BIDS)?

2)
If SQL 2005 complete installation (including BIDS) and SQL Server 2008 complete Install minus BIDS OK?
(and vice versa) - If SQL 2008 complete installation (including BIDS) and SQL Server 2005 complete Install minus BIDS OK?
Avatar of Anthony Perkins
One thing that should be pointed out is that you can install both SQL Server 2005 / 2008 R2 client components and continue to develop SSIS packages using VS 2005 to ultimately run using a 2005 or 2008 R2 database.
Hi,

When you install SQL server whatever version 2005 or 2008, BIDS (VS Shell 2005 or 2008 ) comes with it. No need to install it separate. If you have installed server on different machine and need to develop on different machine then BIDS shell needs to be installed.

Avatar of 25112

ASKER

>>One thing that should be pointed out is that you can install both SQL Server 2005 / 2008 R2 client components and continue to develop SSIS packages using VS 2005 to ultimately run using a 2005 or 2008 R2 database.

are you suggesting to develop only in one version (2005)?
>>are you suggesting to develop only in one version (2005)? <<
No, I did not say that.  I said you can continue to develop SSIS packages using Visual Studio 2005 using either SQL Server 2005 or 2008 or 2008 R2 (or Denali for that matter)
Avatar of 25112

ASKER

>>you can continue to develop SSIS packages using Visual Studio 2005 using either SQL Server 2005 or 2008 or 2008 R2 (or Denali for that matter)

that makes sense.. because 2005 or 2008 or R2 database is 'only' a database for a SSIS package, regardless of the version of the connection string servers, right?

but the question is about the concerns when there is also vs2008 bids on that same machine where vs 2005 is used to make that package..
>>but the question is about the concerns when there is also vs2008 bids on that same machine where vs 2005 is used to make that package.. <<
Correct, if you need to maintain SSIS packages written in Visual Studio 2005 you will need to keep that development tool available.
Avatar of 25112

ASKER

>>Correct, if you need to maintain SSIS packages written in Visual Studio 2005 you will need to keep that development tool available.

OK, I think you mean that if it is developed in 2005 BIDS, then always keep that tool. But it may break when 2008 is also introduced in that machine?

With R2 SSIS, can you make connection strings to all the prior version databases (upto SQL 2000).
Can you do the same connection strings from SSIS 2005. (connect to 2000, 2008, R2, 2005 databases all from one SSIS 2005 package)?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112

ASKER

thanks acperkins.

8080_Diver, can you please confirm the questions on post # 3689363. then this post can be closed.
I suspect you mean #36893639 and those questions have been answered more than once, but if you want to hear it from 8080_Diver that is fine with me.
1)
is BIDS the only point of conflict in the Visual Studio family? Do any other tools clash like this? If VS 2005 and 2008 are on the same machine, are there are any issues like this (other than BIDS)?

Since I am a Development DBA annd primarily work with BIDS, no, I do not know of any other conflicts.  However, that being said, I rather suspect that there may be . . . MS has that kind of habit. ;-)

2)
If SQL 2005 complete installation (including BIDS) and SQL Server 2008 complete Install minus BIDS OK?
(and vice versa) - If SQL 2008 complete installation (including BIDS) and SQL Server 2005 complete Install minus BIDS OK?


As far as I know, the answer to both is, "No/".  Again, though, I am a Development DBA and not an application or web developer.  Therefore, I am providing the information that I know.

Given the above questions, in general, it does not pay to try to install multiple versions of a given Microsoft development tool on a single system unless you really know what you are doing . . . and from the questions (no offense intended), you don't seem to be in that category.  

I had a really horrible experience trying to use BIDS 2005 and 2008 on the same machine and the installs were done by our support team who are really very sharp.
Avatar of 25112

ASKER

thanks all!