I have a question regarding SSIS 2008 and how it handles views. I hope the answer for this question will be a quick "Get a hotfix" heh.
I am experiencing a very odd behavior with setting up a View as a data-source in OLE DB. I have set up a a very simple package (for experimenting) with a Data Flow Task that has only two components, Data-Source and Data-Destination. I have set the data-source
to a view and the destination to a table in the same database.
Note: I am developing the package on the server itself.
- While trying to preview data-source I get an error, "Query Timeout expired (Microsoft SQL Server Native Client 10.0)
- When executing the package Validation, Pre-Execute phases are complete but no rows are passing through the buffer. I have waited over 12 hours before stop the job. Checking the monitoring verified that IO was on 1. And that no object was locked
, which may have caused the package to run so long or not to retrieve data.
- When connecting to SSMS and doing export of data from the view - it also retrieves no data and the process seems to be stuck.