Post reply

DTS import data to 2000 from 2005

  • March 13, 2008 at 7:19 am

    #120508

    I have a DTS pakage running OK. Except with tnsactions.

    I have tested it with a 2000 db as the source to move data from and its OK - DTC is running and network acces is enabled.

    I cannot get the transactions working when using 2005 as the source - do the same checks need to be done on the 2005 SQL server, or is something differnat needed?

    (The 2005 db is a web db admined by someone else who says DTC is running , and network access allowed?)

    Thanks

  • March 13, 2008 at 8:03 am

    #789060

    You might have some issues with DTC accounts across servers. Are both servers on a domain? If not, there are some things that don't work with DTC without changes.

    Why do you want DTC transactions? Are you changing something at the source?

  • March 13, 2008 at 8:43 am

    #789103

    I'm trying to bring records across, periodically - so I am marking them with the date that they move, so next time they are ignored.

    I am using transactions hopefully to move all records and related records, or none at all.

    Are they on a domain - sorry I don't have any understanding of that.:unsure: - EDIT: Yes they rae on differnat domains.

    I presume DTS is the way to go, and transactions seemed to make sense, seems to be nothing worse than something partially happening?

    Cheers

  • March 18, 2008 at 4:40 am

    #790733

    I have had the suggestion that maybe I should create the 2005 server as a linked server? Is this the solution to my problem. Would I still use DTS and/or would transactions work?

    Or if I stick as I am -

    The 2005 server IS on a differnat domain from the 2000 db. Is this why the transactions do not work. If so what can I do to coorect it? (with 2005 and 200 on the same domain - everything seems to be OK)

    Thanks

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

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