Post reply

Default values of columns not transferred in SSIS Transfer Objects Task

  • August 1, 2008 at 11:40 am

    #125338

    Well i m transfering database objects from sql server 2000 to sql server 2005 using the "Transfer SQL Server Objects Task" in SSIS,

    lot of the database tables in sql server 2000 have default values for columns.

    Problem is that -> These default values are not brought over to sql server 2005 by SSIS task.

    how can i resolve this problem..... i have tried all settings for SSIS task...

    i will appreciate if someone can help me...

    do i need to install some service pack or hotfix...

    thanks

  • August 1, 2008 at 11:52 am

    #852072

    Do you have SP2 fro sql server 2005? That is the latest..

    -VG

  • August 1, 2008 at 11:57 am

    #852076

    yes i have SP2 installed

  • August 1, 2008 at 12:05 pm

    #852079

    You must have checked this, make sure you selected, Destination Copy options - CopyAllDefaults to TRUE.

    -VG

  • August 1, 2008 at 12:07 pm

    #852083

    i have tried this too

    copyalldefaults is set TRUE

    but still it doesn't copy defaults....

  • August 1, 2008 at 12:18 pm

    #852088

    I remember like that task does 'nt work for sql 2000. So, better go for alternatives like import and export wizard..

  • August 1, 2008 at 12:30 pm

    #852108

    microsoft must have found some solution to resolve this problem

Viewing 7 posts - 1 through 6 (of 6 total)

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