SSIS 2005 & 2012

  • Hi All,

    I have developed SSIS package In Visual Studio 2010(compatible with SQL2012), But while client running that package in SQL2005, they are getting error.

    So now i want to develop same package in SQL2005. To full fill this requirement, Which visual studio should I install on My machine, or Should I install SQL 2005 ?

    Can you give me any inputs from your end.

    Thanks in advance.

  • To develop SSIS 2005, you need BIDS 2005 (the shell of Visual Studio 2005). You can find this on the installation media of SQL Server 2005.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks,

    I am gng to install SQL 2005, But already I installed SQL 2012 and Visual studio 2010,

    Should I Uninstall Visual Studio 2010 ?

  • PRAMANA.DBA (3/11/2015)


    Thanks,

    I am gng to install SQL 2005, But already I installed SQL 2012 and Visual studio 2010,

    Should I Uninstall Visual Studio 2010 ?

    Not if you ever want to develop SSIS packages for SQL 2012.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply