Post reply

DTS Error debugging question

  • February 21, 2004 at 1:23 am

    #59192

    Hi this has puzzled me for awhile.

    i have a pacage that transfers all objects to another server. I have chosen the option to drop destination objects first. I have also turned on logging errors.

    I receive a number of columns don't match on insert error.

    Two things, first how can I et this error if I am dropping destination objects first?

    Second, How can I find which of the 100 od tables is the source of the problem?

    Unfortunetly the log just provides the same limited error info as the msgbox.

    thanks

     

    Dave

    Trainmark.com IT Training B2B Marketplace
    (Jobs for IT Instructors)

  • February 21, 2004 at 8:42 pm

    #495050

    I experienced problems with transfering objects and the only way I found to identify which objects were the problems was to remove them one by one or in groups and try again.  I hope there is a better way, but I didn't find one.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • February 22, 2004 at 3:28 pm

    #495070

    If you're using the TransferObjects task then you can check the log file created by that task. It's usually in "C:\Program Files\Microsoft SQL Server\80\Tools".

    In this directory, you'll find a .BCP file for each table you're transferring as well as a few other files that are named as <dest server>.<database>.<object type> these are all the T-SQL scripts for recreating the objects you're transferring.

    There is also a .LOG file for the source and destination of your transfer. Either of these two will hold the error message you're looking for.

     

    --------------------
    Colt 45 - the original point and click interface

  • February 25, 2004 at 10:24 am

    #495621

    Thanks Phill, I havn't tracked down the corect file in that directory yet and I'm still trying to sort out what information each file holds.

    I amhoping that the answer is in there. hmm maybe I'll do a text search on that directory for error

     

    Thanks again,

    dave

     

    Dave

    Trainmark.com IT Training B2B Marketplace
    (Jobs for IT Instructors)

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

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