April 16, 2009 at 11:06 am
Hello, I'm pulling my hair out where with an old server I am dealing with. I have a pair of machines SQL Server 7.0 SP3 servers, one for dev and the other for production. I have created a DTS package to pull a data from the Prod to Dev servers.
The first version of the package was just a Data transfer between the servers. It would wipe the data and regenerate it via the Data transfer object. It would run with out error, but after investigation, it was dropping data. The transfer would set some the fields to NULL when there was data in original prod server.
I then had the DTS package manually drop/create the db and then transfer the data. No difference. Still no error or warnings.
Any idea of the issue or better way to diagnose this issue?
April 16, 2009 at 1:11 pm
To clarify, are you using Transfer SQL Server Objects task or a Transform Data task? If it's the former, I suggest using the Transform Data task if you're just copying data.
Greg
April 16, 2009 at 2:00 pm
Greg Charles (4/16/2009)
To clarify, are you using Transfer SQL Server Objects task or a Transform Data task? If it's the former, I suggest using the Transform Data task if you're just copying data.
I'm using 'Transfer SQL Server Objects' with 'Transfer all Objects' checked.
It does transfer almost all of the data, just not some of the fields of the rows.
April 17, 2009 at 10:56 am
Make sure you have all the source columns mapped to destination columns.
Greg
April 17, 2009 at 11:25 am
How about using backup & restore to refresh dev, Don't know much about 7.0, does that work?
Any plans for upgrade?
April 22, 2009 at 9:03 am
Greg Charles (4/17/2009)
Make sure you have all the source columns mapped to destination columns.
I did. I doesn't make any difference.
April 22, 2009 at 9:07 am
SQLRocker (4/17/2009)
How about using backup & restore to refresh dev, Don't know much about 7.0, does that work?Any plans for upgrade?
The data is correct if we put it in manually on the Dev server. It seems that the data is being ignored/lost in the DTS transfer itself.
No plans for a major upgrade. No $$$ for that. I may be able to plan a 7.0 SP3 -> 7.0 SP4 upgrade.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply