Isn't it just me having lots of problems with SSIS?

• Loner

  SSC-Insane

  Points: 21279

  More actions

  August 29, 2008 at 10:00 am

  #94509

  I just want to import data from Oracle to SQL Server and a csv file to SQL Server.

  It would be a piece of cake using DTS and it took me forever to get that done.

  Somehow the data transformation all screwed up.

  Maybe I still need a lot of practice.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 29, 2008 at 1:40 pm

  #865245

  It is probably DTS, not you.

  Try using BCP instead. It will not work on every type of CSV, but when it does, it is much easier than DTS.

  [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]