Viewing 6 posts - 1 through 7 (of 7 total)
I didn't get a chance to install the SP yet, but one thing I did notice was that when it fails, it always fails after 20 seconds. I tried adding...
July 2, 2007 at 12:30 pm
In SSIS, I tried something else...I created an Execute T-SQL Task and put my insert statement in as the statement to execute, and it failed with a the same message. I'll try the...
June 28, 2007 at 7:17 am
Thanks Chris, I did learn that very early on. However, the spreadsheet was not opened in all subsequent tries while getting this error.
Scott
June 28, 2007 at 6:54 am
SSIS had no problems with it. All I got was for each column in the Excel spreadsheet was something like the following:
Warning: 0x802092A7 at Data Flow Task, OLE...
June 27, 2007 at 2:35 pm
Yep, I can try it out in SSIS and see what it reports, if anything. Thanks for the suggestion. And it's only about 250 rows. I tried it with a...
June 27, 2007 at 7:22 am
Thanks Cris, but no, my test spreadsheet is the same set of data each try. That's why it's so annoying.
June 27, 2007 at 6:58 am
Viewing 6 posts - 1 through 7 (of 7 total)