VS - SSIS version mapping

for example, can VS 2003 package considered 2005 SSIS compatible? is there a msdb llink for version compatibility between VS and SSIS..

or should i say BIDS compatibility ? (I am assuming VS 2003 also had BIDS)

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.

does this mean VS 2003 did not have it?
http://msdn.microsoft.com/en-us/library/ms170338%28v=sql.90%29.aspx

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.

so VS2003 can't be used to create a package that will work as SSIS 2005 package, right?

YES, if you have it, please try it...
why do you need VS 2003 anyway?
what's the problem you're having?

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

i need to confirm it, either way, with an official Ms link.

would you have any other link to confirm?

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 !

so even if you did not install SQL 2005 database engine, you can just install BIDS from SQL 2005 CD?

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?

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

thanks for confirming..

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.