Please forgive my initial post was a question instead of a solution.
I have two SSIS packages that basically do the same thing. The last step of both is the Data Flow Task, which queries the database and tries to write the results to a flat file. One of the packages builds a flat file correctly, the other builds a file, but does not fill it with any entries. Starting SQL Server 2008 R2.
This is in a university context involving the transfer of degrees and demographic data between two systems. The degree_code package works, demography is not. Both "Dataflow Tasks" consist of an OLE DB source associated with a flat file assignment (tab delimited text). Both packages display the correct dataset when previewing the OLE DB source.
In Flat Flat Destination, mappings are true in both packages. However, when you preview the data, the degree data is displayed correctly, but there are no entries in the demographic preview. The same can be said of connection managers. And when the packages start, the degree_codes file is correct, and the demographic file contains only the header. There seems to be a problem with the connection between OLE DB Source and Flat File Destination
Both packages run only with a warning about the effectiveness of global global memory. Ive removed and rebuilt the idle task of data flow and connection managers without fixing the problem. At this moment, I am losing direction, and I do not know how to diagnose the problem. Ask either of you to face a similar situation or do you have any suggestions for harassment. I'd be grateful for any decisions.
source
share