Analyze the data and split into tables

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  July 7, 2008 at 4:20 pm

  #194826

  Hi,

  I had received some data files for a new project with 1 million rows and 75 columns. Do we have any utility tool which will split a single table with data into multiple tables after analyzing the data. This feature is available in Microsoft Access (Analyze Table or Table Analyzer Wizard)

  Thanks

  Chandra Mohan N

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  July 8, 2008 at 6:32 am

  #839433

  Nope.

  You can use SSIS to do the work for you, but the analysis is up to you.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning