SCD???

• patla4u

  SSCrazy

  Points: 2103

  More actions

  May 8, 2011 at 7:32 pm

  #237111

  Hi ,,,

  I have one question...??

  Here the situation .... I have flat file coming every months.

  Files will come every month.

  1st file (3/31/2011)

  Name country balance

  raju UK $50000

  keshu USA $5000

  2 file (4/30/2010)

  Name country balance

  raju UK $500

  keshu USA $500

  Finalily they want

  Production database

  Name country balance

  Raju UK $50000

  keshu USA $5000

  raju UK $500

  keshu USA $500

  please let me how to do that ......with ssis ,,,,,,,,,,,,,,,

  I am loading file throght SSIS ....so ....

  Please help me

  THanks

  P

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 8, 2011 at 11:22 pm

  #1321536

  Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1105182-147-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass