Flat File Connection Manager[^] You have to select a different separator in the Columns page. Tabulation may be adequate, or some other character of which you are sure it cannot appear in stored strings. noop()

You want to pull the "most recent months" data. Yes that it possible. Didn't look but I am certain that google will display many answers for that. Add your specific database in do get a more relevant answer.

SSIS has a problem importing data from Excel if the first few rows (5 I think) are in numeric format, but subsequent rows contain data that cannot be parsed as numerical. There is a way of changing the connection from SSIS to get it t not guess the column type - you need to set IMEX=1 in the connection string Check this article - [Importing data from Excel having Mixed Data Types in a column (SSIS) | Tech Updates](https://munishbansal.wordpress.com/2009/12/15/importing-data-from-excel-having-mixed-data-types-in-a-column-ssis/) ========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================