I have an Integration Services project which creates a flat file report from Analysis Services, I'm using an OLE DB as data source and running an Openquery in the SQL statement.
the problem is that Integration services runs the query twice before getting the data into the flat file. I know this because the query runs two times in Profiler, and because the same query takes half the time whenÃÂ run in Management Studio.
Integration Services is runningÃÂ the whole query when validating. how can I disable this validation or better make it validate properly.
View Complete Post