Post reply

Problem using the Copy SQL Server Objects Task in DTS Package

  • December 8, 2005 at 8:42 am

    #112835

    Hi I have a problem using the Copy SQL SERVER OBJECTS TASK IN dts.  I am running SQL Server 2000 .818 on a Windows 2003 server.  I have a package that is built and the only thing inside of it is a copy sql server objects task.  We are trying to move data from our OLTP to a Warehouse staging area but the data is never delivered.  Is there something else I need to setup in the package?  I have even tried sending data on the same server to two different DB's it will move the schema but never the data.  Any help on this would be appericated.  Oh everything works fine with I just do a regular export of data via EM and then save as a DTS package but I thought it would be a lot easier if I could just setup one Copy SQL Server Objects Task.

     

    Thanks

  • December 8, 2005 at 12:49 pm

    #608519

    I've had issues with this task and so have avoided it.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • December 9, 2005 at 3:07 am

    #608599

    I've just had a similar problem whereby the job would fail after it had copied the table structures. 

    I eventually solved it by changing the options on the copy objects task to not copy users across.  Only found out this was causing the problem by enabling logging of the dts package.

    Hope it helps

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • December 9, 2005 at 9:16 am

    #608708

    Ok so I turned the logging on and even though the package says it completes successfully I am seeing the following error produced for every table.  I checked the two servers and the dll dates match.

     

    ::Error::

    In file  in statement on line 0

    Transfer Status: Transferring Data: (Table '[dbo].[Activity_Type_Trans]')

    [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatch

  • December 12, 2005 at 1:34 am

    #608945

    Theare the files that must have matching versions

    %SystemRoot%\system32\sqlsrv32.dll

    %SystemRoot%\system32\sqlsrv32.rll

    %SystemRoot%\system32\odbcbcp.dll

    There is a free Microsoft tool that can be used to check versions.  Below is the link.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

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

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