Emailing to SQL Server

• Richard Gardner-291039

  Hall of Fame

  Points: 3603

  More actions

  January 20, 2006 at 3:29 am

  #167755

  Hi,

  I want to send a .csv to my 2005 server via email and get SSIS to parse the csv automatically.

  Does anyone know if this is possible?

   

  Thanks

  Rich

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  January 20, 2006 at 11:24 am

  #616180

  I do not think you can do that unless you had an ability to read an e-mail.  Either move it there through cmdshell or FTP through CmdShell.