Post reply

Unable to copy user-defined functions

  • August 22, 2006 at 3:43 am

    #119329

    Hi Folks,

    I am trying to copy all user-defined functions in my old SQL Server 2000 to SQL Server 2005 via Transfer SQL Server Objects Task but it seems none have been copied. Please help. Thanks.

    Object property for CopyAllUserDefinedFunctions is set to "True".

    Debug log:

    SSIS package "copy user-defined functions.dtsx" starting.

    Information: 0x4002F418 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Logins to transfer.

    Information: 0x4002F41D at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Users to transfer.

    Information: 0x4002F362 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Rules to transfer.

    Information: 0x4002F366 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Tables to transfer.

    Information: 0x4002F370 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Views to transfer.

    Information: 0x4002F358 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Stored Procedures to transfer.

    Information: 0x4002F378 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Defaults to transfer.

    Information: 0x4002F382 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Data Types to transfer.

    Information: 0x4002F386 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Functions to transfer.

    Information: 0x4002F390 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Schemes to transfer.

    Information: 0x4002F394 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Schemas to transfer.

    Information: 0x4002F398 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no SqlAssemblys to transfer.

    Information: 0x4002F402 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Aggregates to transfer.

    Information: 0x4002F406 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Types to transfer.

    Information: 0x4002F410 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no XmlSchemaCollections to transfer.

    SSIS package "copy user-defined functions.dtsx" finished: Success.

    Kindest Regards,

    SQL 2000 (Clustered)/SQL 2005

  • August 22, 2006 at 7:05 am

    #656101

    Hello,

    It is better if you can script your user-defined functions and run the same on SQL 2005 box.

     


    Lucky

  • August 22, 2006 at 8:49 pm

    #656265

    lucky,

    well, that's the last thing i will do. as you have said, run the script one by one, anyway it's only 38 scripts that need to be copied...but still I would like to know what others have experienced using the task. Thanks.

    Kindest Regards,

    SQL 2000 (Clustered)/SQL 2005

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

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