July 16, 2007 at 9:23 am
I'm in the process of writing a package that takes data from SQL and the writes a flat file so our UNIX system can read and process it. This process is critical. What's the best way to verify that the SSIS package was able to completely write the file?
For example, let's say the network crashed, or the shared drive i'm writing to crashed during the write process. Will SSIS catch this and throw an error?
I was thinking that if after the write I had SSIS read the file back and check for the EOF marker then that would be sufficient.
Any ideas would be most appreciated.
July 17, 2007 at 2:25 am
It would catch it. It would be a IO access denied or read write error.
A simple test would be to write to a UNC path and while writing, disconnect from the network. It'll through an error and depending on how you setup your package, it'll fail. By default, it'll fail.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply