Best approach

• Al Sallam

  SSC Veteran

  Points: 299

  More actions

  May 27, 2011 at 6:09 pm

  #251815

  I have a task of importing 3 different files into a datamart db table. I am new to ssis and need some help as for someone to guide me to what would be the best approach to accomplish my task. I have the following scenario:

  3 different files in the following formats:

  XML, XLS, CSV

  Need to import them into a table with the following data types:

  varchar(1) to varchar (8000)

  smalldatetime

  int

  float

  datetime

  money

  smalldatetime

  I need to creat this in one package if possible.

  It would help me a lot to know what would be the best data types (i.e. DT_I4, DT_NUMERIC, DT_STR, etc.) to map from the files to the data types in the sql table listed above.

  thanks for your help

  Al

• Jim Murphy

  SSCertifiable

  Points: 6263

  More actions

  May 27, 2011 at 6:35 pm

  #1331273

  Al,

  You may find better results posting in the SSIS forum, rather than SQL server 2008 newbies. You'll get more SSIS talent finding your post and answering.

  Jim Murphy
  http://www.sqlwatchmen.com
  @SQLMurph

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  May 27, 2011 at 9:31 pm

  #1331287

  Gosh, this one sounds a whole lot like homework, a test, or an interview question. 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)