We are going to transfer data from denormalize db to normalized db.Currently both source and destination are on same server..

but once i complete creating packages for all tables ,...

Hi,

I got the solution..

I need to use separate data source for each left join..

so i have used multicast for source table then done left join .

i have attached screenshot of...

Data sources are SQL command like

select * from Mst_From_Email where Company_ID = 1 and active = 1

Hi,

Is there any other advantages of using SSIS over using script , except faster loading for data transfer?

Thanks,

Megha

ok...thanks..SSIS will be fast over script in case of different server data transfer?

Actually, we have tables with more than 150 columns and it's harder to manage it (insert) .

so tables are denormalized now.

source and destination databases are on different server.

Thanks,

megha

Hello ,

you can also try below

;WITH CTE AS

(

SELECT docid,pages FROM #x

UNION ALL

SELECT C.docid,C.pages-1

FROM #x X INNER JOIN CTE C

ON X.docid = C.docid

AND C.pages-1 >0

)

SELECT *...

Hi,

i have already tried with html format but there was problem in convert from xml to varchar ,because of large xml ,it was truncated.

At last,i have changed my query to...

Try this ..

SELECT A.* FROM Employee A ,Employee B WHERE A.DateofBirth = B.DateofBirth AND A.id <>B.id AND (A.SSN = B.SSN OR A.EmployeeCode = B.EmployeeCode)AND A.Division = B.Division