SSIS Pavkage

[deepa]

I have created view with sub queries.

Basically query checks audit tables and returns the changes for current date.

It takes about 8 sec to result 8 rows, however it takes forever to export the data to excel from export wizard and using SSIS package. Below is sample of view

Alter view VIEW1 as

Select A, B, filename
from table1
where A+B in (select A+B
from table2
where DATEDIFF(day,Date_Update, GETDATE())=0
UNION
Select A+B
from table3
where DATEDIFF(day,Date_Update, GETDATE())=0
UNIOIN
Select A+B
from Server1.DB.table4
where DATEDIFF(day,Date_Update, GETDATE())=0)

Any ideas what could be the problem? I have linked server to read the datachanges from different server audit table.

Thanks in advance.

[ravinder_k]

you might be able to find the answer in Linked Server Properties (Server Options Page). I would play with collation compatibility issues on this options page.

[Island1]

Are you applying SSIS to two MSSQL Server 2k5 environments?

Thanks.

Bill