Please change the Title/Subject of this article.

This has nothing to do with OPENQUERY. It's very misleading. There is no such limit on OPENQUERY.

Thanks

Extremely academic -- since as was pointed out, the file must be on a disk local to that instance of the SQL Server. Doesn't happen often and...

This only works for the most of trivial samples.

Academic and won't work for real world cases.

Try using it on over a gig of XML data and watch it blow...

While it offers a very brief sample to get going fast it should at least list other alternatives since some of them are quite nice. Readers need to be aware...

I think what needs to be discussed/understood is that SSIS packages can exist and run as part of a production environment without living on a SQL server. I believe...

Yes I did resolve this and it works quite well now.

It a matter of both the attributes you give the Bulk Load Object and how the tables are setup.

For the...

I took the dnld from the article and tried in vain to compile/deploy/run the Solution.

I'm failing with the following:

L:\ZipStuff\XLSExport\XLSExport\bin\Debug\iCExport.sql(39-39): Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6503, Level 16,...