SSIS Vs sql import export performance

• snsingh

  Right there with Babe

  Points: 793

  More actions

  September 22, 2011 at 2:01 pm

  #244217

  Hi All,

  I am using sql 2008. I have to import 130 million record into sql server. source and destination both are both sql server 2008. I make a job to import data and in that job I call ssis pkg. SSIS pkg don't have any transformation. it only have simple two transformation i.e sql source and sql destination(using OLEDB connection). I'm getting very poor performance with this job

  while, when I'm using sql import export wizard is very fast. can some one help me out what happening here.

  Thanks

  Sneh

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 22, 2011 at 2:24 pm

  #1385444

  Please don't cross post. It just wastes peoples time and fragments replies.

  No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1179722-364-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

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  September 22, 2011 at 2:27 pm

  #1385445

  <Answer moved>

  ---

  - Craig Farrell

  Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

  For better assistance in answering your questions[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA