try below query with CteDental1201 as ( select count(*) as productivity,project,process,datename(month,date) [month] from dental201 group by project,process,date ) select project,process,productivity,ProcTarget.Proc...

try this link [http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405b604614/][1] [1]: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405...

try this link [http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405b604614/][1] [1]: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405b60...

see the link [http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html][1] [1]: http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html...

see the link [http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html][1] [1]: http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html...

Please Mark this as answer if it is working or reply if any problem. so this question is closed....

Please Mark this as answer if it is working or reply if any problem. so this question is closed....

Full-Text is token (word) based search and not a substring search. Therefore it will not find arbitrary 3 char string patterns in middle of strings. read the reply of Sara Tahir in above link...

Full-Text is token (word) based search and not a substring search. Therefore it will not find arbitrary 3 char string patterns in middle of strings. read the reply of Sara Tahir in above link...

Data flow Flat file source-> Derived Column -> Destination in derived column you have to set like below Replace c1 with REPLACE(c1,"\"","") Replace c6 with REPLACE(SUBSTRING(c6,1,LEN(c6) - FINDSTRING(REVERSE(c6),",",1)),"\"","") ...