SSIS data flow validation failure on snapshot read

0

I have two database snapshots of the same source DB on my server with sql server 2008 R2. One of them is corrupted (marked suspect). My ETL does not read the corrupted one but is still failing validation for a data flow task when it is reading a view hosted on the good snapshot. The good snapshot does not refer to any entities in the corrupted DB snapshot. Is there any reason for this happening?

Error Code -

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "Database 'XXXXX_SS' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Error Log The operating system returned error 665(The requested operation could not be completed due to a file system limitation) to SQL Server during a write at offset 0x000011579d6000 in file 'X:\X\XXXXX_4NSS.ss'.

sql-server
ssis
snapshot
asked on Stack Overflow Apr 19, 2015 by SQLMonsta • edited Apr 20, 2015 by SQLMonsta

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0