Default values of columns not transferred in SSIS Transfer Objects Task

• harmanocp

  Mr or Mrs. 500

  Points: 562

  More actions

  August 1, 2008 at 11:39 am

  #195173

  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

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 1, 2008 at 12:49 pm

  #852132

  Please do not cross-post.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]