Loading Fixed Lenght Text File

• naveenreddy.84

  Ten Centuries

  Points: 1252

  More actions

  October 12, 2009 at 4:02 am

  #139527

  Hi All,

  Is it possible to load the fixed lenght text file into a database table using TSql Statement and without using an SSIS package

• Allister Reid

  SSCrazy

  Points: 2666

  More actions

  October 12, 2009 at 5:58 am

  #1064670

  hey, try http://msdn.microsoft.com/en-us/library/ms162802.aspx

• dsdeming

  Ten Centuries

  Points: 1236

  More actions

  October 12, 2009 at 6:40 am

  #1064687

  You can also use BULK INSERT from within a stored procedure or query without having to use xp_cmdshell.