we have a source excel file and the destination is flat file in the ssis , i have created a package earlier which have OLEDB source and flat file destination by using store preocedure i created headers and fotters in the flat file ,but now this time requriment is changed we have excel source and flatfile destination with same logic as Storeprocedure has ,is there any way for i Think excel to sql and than sql to csv in data flow task.