Solved

VS - SSIS version mapping

Posted on 2011-09-28
19
237 Views
Last Modified: 2013-11-10
which version of Vs maps to ssis?
0
Comment
Question by:25112
  • 11
  • 5
  • 2
  • +1
19 Comments
 
LVL 5

Author Comment

by:25112
Comment Utility
for example, can VS 2003 package considered 2005 SSIS compatible? is there a msdb llink for version compatibility between VS and SSIS..
0
 
LVL 5

Author Comment

by:25112
Comment Utility
or should i say BIDS compatibility ? (I am assuming VS 2003 also had BIDS)
0
 
LVL 21

Expert Comment

by:huslayer
Comment Utility
was there BID 2003! I don't think so, but can't confirm...
I know for sure that 2005 is for SSIS 2005 and 2008 for SSIS 2008 !

SSIS Packages designed in VS 2008 CANNOT be run in VS 2005 or installed in
SQL 2005 instances.

However, packages desinged in VS 2005 CAN be installed in SQL 2008. But if
you open the package in VS 2008, it will want to upgrade the package, making
it un-usable for 2005 versions.
0
 
LVL 5

Author Comment

by:25112
Comment Utility
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 75 total points
Comment Utility
ETL PAckage : SQL SErver 2000

SSIS BIDS 2005 : SQL SErver 2005

SSIS BIDS 2008 : SQL SErver 2008
0
 
LVL 21

Expert Comment

by:huslayer
Comment Utility
Yep, I also never worked or ever saw how it looks like, but can't get anything when I search for bids or vs 2003 for ssis.

it was implemented starting in VS 2005.
0
 
LVL 5

Author Comment

by:25112
Comment Utility
so VS2003 can't be used to create a package that will work as SSIS 2005 package, right?
0
 
LVL 21

Expert Comment

by:huslayer
Comment Utility
YES, if you have it, please try it...
why do you need VS 2003 anyway?
what's the problem you're having?
0
 
LVL 5

Author Comment

by:25112
Comment Utility
a developer has VS2003, and management wants(hoping he can) him to develop 2005 package, since they don't have license for another VS2005 for him right now.. if it is not possible, they will get VS2005 license..
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 5

Author Comment

by:25112
Comment Utility
i need to confirm it, either way, with an official Ms link.
0
 
LVL 5

Author Comment

by:25112
Comment Utility
would you have any other link to confirm?
0
 
LVL 21

Expert Comment

by:huslayer
Comment Utility
Of course not, he can't do that...without a link or anything...
If it's 2003 how it'll develop 2005 packages!! it doesn't even make sense!

All what he needs is to install BIDS from the SQL 2005 CD, client tools, and he can develop, he doesn't need the whole VS !
0
 
LVL 22

Assisted Solution

by:8080_Diver
8080_Diver earned 150 total points
Comment Utility
VS 2003 did not have a BIDS because BIDS didn't exist until SQL Server 2005.  Therefores VS2005 is the earliest with any sort of BIDS.  

Now, the Good News.  If y'all have the Issue Discs for SQL Server 2005, BIDS is a Client Tool that can be installed from the SQL Server install discs and it doesn't require a separate license.  However, the BIDS install will only be able to do SSIS development.
0
 
LVL 5

Author Comment

by:25112
Comment Utility
so even if you did not install SQL 2005 database engine, you can just install BIDS from SQL 2005 CD?
0
 
LVL 5

Author Comment

by:25112
Comment Utility
what i meant to ask if if the developer just has BIDS and not any other part of SQL Server 2005, can they develop package with connection strings to other SQL Servers.. and is it OK to have SQL 2008 completely installed in that developer's PC.. hopefully they will not conflict?
0
 
LVL 21

Accepted Solution

by:
huslayer earned 275 total points
Comment Utility
YES, he can do that, from the 2005 CD
No Conflict at all.

Under      \Tools\Setup folder of your SQL Server Setup CD
Run         SqlRun_Tools.msi

0
 
LVL 5

Author Comment

by:25112
Comment Utility
by "hopefully they will not conflict?" i meant that they can develop ssis 2005 packages wtih the new BIDS that they will installed from SQL2005 CD.. and they can also develop 2008 SSIS packages.. and there will conflict while they develop in both environments in the same PC.. but no SQL 2005 database engine, but complete 2008 install..
0
 
LVL 5

Author Comment

by:25112
Comment Utility
thanks for confirming..
0
 
LVL 22

Expert Comment

by:8080_Diver
Comment Utility
and is it OK to have SQL 2008 completely installed in that developer's PC

BIDS for SQL Server 2008 does not play well with BIDS for SQL Server 2005.  If 2008 is installed first, then 2005 doesn't want to install.  If 2005 is installed first, then 2008 will modify some of the components in the 2005 setup and 2005 will not work.

Been there, done that, didn't enjoy it.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now