got it solved

Thanks for the clarification

You can change in Flat File Source Connection manager. Just Double click the connection manager you should be able to make the changes.

got it solved thanks

No strong words plz.....

We Can Perform this operation by having more than one FST in Control Flow.In Each FST you can specify the destination Folder path and source file also.

I...

Thanks it worked.

When destination is excel. We need to make sure data type is always DT_WSTR

Got it solved. Thanks,

why do you want to write script . It can be done easily using FileSystemtask.

If you have real experience working with SSRS. You should answer all the questions 🙂

Refer this URL. should help you great bit

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/

I got it solved thanks a lot guys

Please find the table structure as below

CREATE TABLE Contact

(

FirstName varchar(100),

MiddleName varchar(100),

LastName varchar(100),

ContactId int,

CONSTRAINT pk_Contact_pid PRIMARY KEY(ContactID)

)

Can be done using temp table for your reference

SELECT EmpID,EmpName INTO #temp

FROM Employees

GROUP BY EmpID,EmpName

HAVING COUNT(*)>1

DELETE Employees FROM Employees a INNER JOIN #temp b ON

a.EmpID=b.EmpID

INSERT INTO Employees(EmpID,EmpName)

SELECT EmpID,EmpName FROM...