DTS Weird happenings

Question

DTS Weird happenings

JKSQL

SSCrazy Eights

Points: 8481
More actions
May 2, 2006 at 1:35 pm

#366093

So a month ago I got a call saying my data was screwed up on an import. so I went in and sure enough the fields were mapped inncorrectly. Kind of strange I thought since I did not change this DTS but I questioned myself. So I just got the same phone call and again the mapping issue is back. I corrected it and now the data is good. Is there a particular issue that this mapping problem could come up again like that? If so how to get around it?

Viewing 11 posts - 1 through 10 (of 10 total)

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

shailendra-251422 Ten Centuries Points: 1111 More actions · Answer 1

I have faced the same problem in DDQ a couple of times. The column names and parameters get mismatched on their own. DTS is haunted

Richard-264095 SSC Rookie Points: 31 More actions · Answer 2

Richard-264095

SSC Rookie

Points: 31

May 3, 2006 at 7:09 am

#635585

I have experienced a similar situation.

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 3

Thats just spooky. Well maybe I will change the Name. Maybe it is crazy like that

kevin mann Hall of Fame Points: 3894 More actions · Answer 4

Is it a result of adding/removing fields in a table, view, or view dependency (table) that is used by the DTS?

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 5

No literally it was a working process. I have not touched the process for months

kevin mann Hall of Fame Points: 3894 More actions · Answer 6

kevin mann

Hall of Fame

Points: 3894

May 3, 2006 at 9:28 am

#635682

Not the process (DTS)... the database

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 7

I do updates to the database but the tables involved have not been touched. Not to make a conspiracy theory but I am pushing data from SQL 2K to SQL 2k5

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 8

Wait I am sorry I am pulling from Navision odbc to SQL 2k. The transformation from 2k to 2k5 is working properly. Not really a big deal. i was just curious if there was an easy answer

Joanie Jeffcoat SSC Veteran Points: 267 More actions · Answer 9

OK...must be the "NAVISION" thing! We're getting ready to do a Navision upgrade and I'm worried that it's going to break custom reports we already have published.

We've also experienced a few wierd things with DTS packages. In migrating DTS packages I've re-mapped to the servers, I've saved them, then run them only to find they never saved the new mapping and were still pointing to the old server!

Has anyone experienced this with SQL2005?

KSWile SSC Rookie Points: 40 More actions · Answer 10

If you're running the DTS package as a scheduled job, make sure you're referencing the package guid and not the version guid. It sounds like an older version of the DTS is being executed or saved over the newest version. Your current version could also revert to an older version if there has been a restore of the msdb database, since that's where DTS package objects are actually stored.

As for changing the information in a connection, I have had cases where I then also have to reselect my source and destinations in my transformations to completely commit the change.

I've been using SQL Server 2000 DTS for quite awhile and don't recall issues of mappings redoing themselves, only if you edit the source or destination and get that pop-up that asks if you want to redo the mappings.