select ID,Division,DateofBirth,SSN,EmployeeCode from Employee as a

where a.Division=(select Division from Employee b where a.Division=b.Division

group by Division having COUNT(*)>1)

and DateofBirth=(select DateofBirth from Employee b where a.DateofBirth=b.DateofBirth

group by...

I have tried this it worked

Created two data flow tasks one for 'Geetapc14' table and one for Geetapc15

1. For the first data flow task selected source as...

Try this for better performance

WITH C AS

(

SELECT *, ROW_NUMBER() OVER(PARTITION BY ID ORDER BY (SELECT 0)) AS rn

FROM MyTable

)

DELETE FROM C

WHERE rn>1

Fairly simple steps i have given.

Conditional Split is the best method for such cases.

I get header with all the columns entered or selected. But data section it shows empty

Could please help me to regarding one more issue

I want to replace not null data with some other data

for Ex

In previous case we replaced null with some data. I want...

One simple way is Mark IsStoredProcedure flag to '1'

Execute the stored procedure same as you do in Query Analyzer in Sql Server 2008

Got it solved.

Need to use

Tools->Options->Click on Solutions and Projects and Solutions node->Click on general->Enable option “Always Show Solution”.

Most of the time this issue occurs when you the target URL is incorrect.

Pass Web Services URL when you are deploying the report.

Mention the port number also in target URL

For...

Entered

""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=\"Excel 8.0;HDR=YES\";"" in expression window

when you evaluate expression Following value is displayed in expression window

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="Excel 8.0;HDR=YES";

here =" + @[User::FileName] + "...

That's correct if you do at the query level. It will eliminate all issues

You are accessing the wrong URL.

try below steps.

First you need to configure report url in

'Reporting Services Configuration Manager'

Steps you need to follow

1.Go to 'Reporting Services Configuration Manager'

2.Click on web...

Thanks this was very useful. I needed ready only permission. Now i am able to access all databases in SSIS using SQL Server Authentication.

Definitely will go through all the roles.

Do not select database from 'Select Or Enter a database name'

Just type 'msdb' and test the connection.

Thanks,

Praveen