Hi, A quick question for max column issue in SSIS: I am trying to read in csv file with 1,605 columns but failed, is it because SSIS have the same limitation of max columns as SQL Server , which is 1,024 ? PS: i am using SQL Server 2008 Enterprise Edition Regards yongyang

Hi btsbee, Thanks fro the reply, I am quite a newbie on SSIS, would you mind provide a bit more info for how to splitting the files? cheers

Well what i meant by splitting files was instead of doing something complicated to in SSIS can you get the publsiher to publish instead of one source csv file with 1605 columns to multiple csv files with lesser columns. If some columns do not contain data to be imported then these columns can be skipped completely. This just simplifies the ETL process. Is your destination going to be a sql wide table?http://btsbee.wordpress.com/