Thanks.  You are correct.  My issue was the inserts were being done by a different user than I had specified for "principal".

Did this end up working?  Where is the "ReportViewer webpage"?  I'm using 2008 R2.

BeyondRelational.com is down. Where is "X" defined in this query?

DECLARE @StartTime DATETIME,
  @EndTime DATETIME
  
SELECT @StartTime = '20110929', @EndTime = '20110929'...

It doesn't generate a complete insert statement, just the first part.

Also, this functionality is already built into SQL Query Analyzer.

It doesn't generate a complete insert statement, just the first part.

Also, this functionality is already built into SQL Query Analyzer.

It doesn't generate a complete insert statement, just the first part. 'Insert into tablename(columns...)'

Also, this functionality is already built into SQL Query Analyzer.

It doesn't generate a complete insert statement, just the first part. "Insert into tablename(columns...)"

Also, this functionality is already built into SQL Query Analyzer.

Steve - Could you please give some specifics?  Which "suspect" governments has Google done business with?  When did they do the business and what was the transaction?

Same for Microsoft, etc.

Thanks.

That doesn't work, but specifying this format file works....

8.0

2

1    SQLCHAR    0    3    ","     1     col001     ""

2    SQLCHAR    0    7    "\n"  2     col002     ""

Thanks anyway!

I don't think this will be helpful because you won't get the linefeed characters in the post.  If you email me at mikeotown@msn.com, I can send you a sample...

Thanks for the reply, but I don't see how that helps.  I have already tried specifying \n as the row terminator.