Hi, I am importing from one SQL server to another using the standard Data Flow task. Within that task I use the SQL command as the Data access mode i.e SELECT * FROM view_A. Dumping the resulting 23940 records straight into TableB. It has been working fine until it failed last night, with the following message "Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation." However when I check the data there are No NULL values. What I have discovered though is if I change my SQL statement to read SELECT top 23939 * FROM view_A it works! For some reason returning one less works, but the full set fails. If I place the data being returned by the view into a temp table on the source server (via a SQL insert statement) and change the SSIS source to SELECT * FROM table_A it works fine?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSIS problem importing full recordset fails but is ok when one less
- Thread starter rackman99
- Start date
- Thread starter
- #2
Update on this - with it working as a direct Table to table style transfer I though I would create a data flow task where viewA goes into TableA (all on the same server). Again it failed (same as above). Yet it works when its run via a INSERT INTO SQL Script....
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question