Post reply

2005 SSIS connection to SQL Server 2008

  • January 6, 2010 at 3:42 am

    #156553

    We are currently in the process of migrating one of our applications to SQL Server 2008. The SSIS packages are sitting on SQL Server 2005 and will need to point to SQL Server 2008 as a connection source. Are there any known issues with doing this?

  • January 7, 2010 at 11:55 am

    #1100417

    If you can create the connection in the package and it tests ok, there shouldn't be any issues.

  • January 7, 2010 at 6:32 pm

    #1100644

    This can be done (connecting to SQL 2k8 database from SSIS 2K5 package). As was suggested, test your connections first from within the package.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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