InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:32:05 GMT20http://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxHi Andy,I've got this error while trying to OPENDATASOURCE:"Msg 7403, Level 16, State 1, Line 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered."Where do I register it?ThanksThu, 15 Oct 2009 15:08:38 GMTnroudakhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxHi Andy,Did you eventually get the answer to your question? I am looking to do something very similar and would really appreciate some tips if you got yours working.Thank you,MelissaMon, 08 Jun 2009 10:42:35 GMTetudiantehttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxGood video (apart from the blurriness), thanks.But it would be useful for this and all other videos if you could make the code available (apologies if it is and I've missed it).Wed, 15 Apr 2009 02:20:45 GMTSQLSimonhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxNice Video,Informative however the video was not that clear. Images were a bit hazzy. Should have previewed before he posted it.Thu, 09 Apr 2009 14:00:53 GMTsherif.hamawyhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxNice video! I had a follow on question regarding using OpenDataSource to load a text file in CSV format, like this:[code]SELECT * INTO dbo.stage_text_data FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source = C:\; Extended Properties = "Text;HDR=NO;"')...test#csv[/code]I am trying to load the contents of a text file into a SQL Server staging table so that I can perform some data validation on it. I am using the syntax above to create this stage table.In cases where the source CSV/text file is somehow invalid, like mismatched number of columns on each row, the statement above will still import it, simply creating the number of columns needed to equal to the max number of columns from the file. I would like to be able to do some validation on this file before it is even imported, because if each row does not have the same number of columns, then I don't want to continue processing. Example invalid file, in which there are only supposed to be 3 columns: first name, last name, phone number:[code]Andy,Smith,888-555-1234Joe,Jones,999-555-4321,222-444-9898[/code]You can see that the 2nd row has 4 columns, and I would like to simply fail importing the entire file. I have tried researching ways to accomplish validating this, but have not come up with anything.Regards,Andy T.Thu, 09 Apr 2009 11:21:25 GMTAndy Torgersonhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxHi Andy,I love this short video training. Gets right to the point and shows you how to do something. I heard you mention a video on linked servers, where is that located?Have a God One,SQL BatmanMy email is bedgar@aeshr.comThu, 09 Apr 2009 07:47:39 GMTbedgarhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxGood video.Thu, 09 Apr 2009 06:30:10 GMTwadhwa.harishhttp://www.sqlservercentral.com/Forums/Topic692618-29-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Video/66412/">Using OpenDataSource - SQL School Video</A>[/B]Tue, 07 Apr 2009 16:50:16 GMTAndy Warren