scheduling text files

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  December 2, 2010 at 3:05 am

  #241967

  Hi,

  I am having 10-12 .txt files and columns of all files are same.I have to import these text files into sqlserver database.I have to create package which will run on daily basis automatically.How can i do this?

  Thanks in advance

  Abhas.

• shanu.hoosen

  SSCrazy

  Points: 2227

  More actions

  December 2, 2010 at 3:28 am

  #1257772

  create the ssis package and schedule it from sql server agent