Importing .txt, .csv or .xlsx files into Database using SSIS

• NoviceJatt

  SSCommitted

  Points: 1671

  More actions

  July 7, 2010 at 2:01 pm

  #237309

  Hi,

  I have few .txt and .csv file which I want to import into database "DB1". I'm using SSIS to do this.

  Actually I want to import multiple files from a folder into the database. There is data import\export Wizard, but I only want to use SSIS and develop a package that imports multiple files with different columns at one time into the database so that I can create various reports from the tables.

  Can you guys give me any ideas how to do that ?

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  July 7, 2010 at 6:50 pm

  #1189941

  Novicejatt (7/7/2010)

  ---

  I only want to use SSIS

  Are you sure you posted in the right forum? SSIS was new to SQL Server 2005. SQL Server 2000 has DTS.

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.

• Arjun SreeVastsva

  SSCertifiable

  Points: 7150

  More actions

  July 14, 2010 at 1:25 am

  #1192601

  hey can you use dts method in sql 2000

  or if u want please post in the sql server 2005 filed in the Forums