May 16, 2014 at 10:23 pm
Hi All,
Not sure if this is right section or not, but here's my question.
I have created lots of SSIS .dtsx ETL packages for SQL 2005 using Visual Studio 2005 on a 2003 R2 server . Now I need to export them to a 2008 R2 64bit server with SQL 2008 server environment.
I initially tried using visual studio 2010 (which server team installed) but found you couldn't us it for SSIS. Then I asked for Visual Studio 2008 but also found that (though I might be wrong) is also not used for SSIS .dtsx development.
Apparently I need to be using Business Intelligence Development Studio which is a separate optional install in the SQL server install. Can anyone confirm that this is correct? getting a bit frustrated, any help would be great.
Thanks
May 18, 2014 at 1:26 am
ringovski (5/16/2014)
Apparently I need to be using Business Intelligence Development Studio which is a separate optional install in the SQL server install. Can anyone confirm that this is correct? getting a bit frustrated, any help would be great.
You are right, you'll need BIDS for SSIS 2008 import and development.
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply