Post reply

SSIS and SQL Server 2000

  • February 13, 2012 at 6:54 pm

    #250628

    I know this maybe a dumb query but hoping for a reality check.

    I want to create an SSIS package to run on SQL Server 2005 but it will be pulling data from and writing to a SQL Server 2000 instance.

    My thought is that as long as I make the connections right and stick to 2000 compliant T-SQL I should not have a problem here? Any thoughts about this or things I need to consider as possible issues?

    Thanks,

    Sean

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • February 13, 2012 at 7:01 pm

    #1446597

    As far as SSIS is concerned, your SQL 200 source is just like any other data source. As long as you use the correct syntax for the data source, SSIS will be perfectly happy.

  • February 13, 2012 at 7:09 pm

    #1446598

    Thanks SSCrazy. Was pretty sure of that but down to a few volts in the powerhouse at the moment 🙂

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • February 14, 2012 at 8:08 am

    #1446858

    I would have to agree, SQL 2000 is just another data source and you should have no problems as long as you keep the syntax in mind.

    CEWII

  • February 14, 2012 at 9:45 am

    #1446933

    Thanks for your reply CEWII

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

Viewing 5 posts - 1 through 5 (of 5 total)

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