import text file

• bestjudy

  Grasshopper

  Points: 12

  More actions

  May 16, 2002 at 5:44 pm

  #104941

  Hi,

  I want to import text file (comma separated) to sql using DTS in VB. If there is no column name specified in the text file, how can I assign column name to it in the following code section? Thanks for help!!!

  Set oColumn = oTransformation.SourceColumns.New("WhatColumnName" , i_loop_cnt)

  oColumn.Name = "WhatColumnName"

  Edited by - bestjudy on 05/16/2002 5:45:41 PM

• bestjudy

  Grasshopper

  Points: 12

  More actions

  May 17, 2002 at 1:44 pm

  #429392

  Never mind. I found the solution.