Hi SSIS 2010 How do you please stop the commas or delete the commas..when sending data from a dB source SQL to a flat file txt file please Just using col1 col2 col3 as column names Table name is Recipe Chicken,mushroom,cheese I wish to have Chicken mushroom cheese Basically a space instead of comma Please help?

Hi I wish to only begin a select statement if the top value date is found. It's my way of knowing data has been added into a system at the beginning of the month e.g max date is 01/01/2018. If not take the last day of the month 31/10/2018. Table is called sales. Column is called SaleDateFrom. I want to pull e.g data from SaleDateFrom <=01/01/2018...if not pull data SaleDateFrom <=31/12/2018 Any ideas team?

Hi Have a column in excel with department code like 23.45.345 I can't seem to import this column into SQL server table 2012.. trying a derived column with no joy...even tried formatting to string and SQL column is formatted to nvarchar Please help