Two BULK INSERT issues I worked around recently

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Mon, 14 Jun 2010 23:23:00 GMT Indexed on 2010/06/15 1:13 UTC
Read the original article Hit count: 350

Filed under:

bulk insert

|

cross-platform

|

formatting

|

linked servers

Since I am still afraid of SSIS, and because I am dealing mostly with CSV files and table structures that are relatively simple and require only one of the three letters in the acronym "ETL," I find myself using BULK INSERT a lot. I have been meaning to switch to using CLR, since I am doing a lot of file system querying using xp_cmdshell, but I haven't had the chance to really explore it yet. I know, a lot of you are probably thinking, wow, look at all those bad habits. But for every person thinking...(read more)

© SQL Blog or respective owner

Related posts about bulk insert

Oracle pl\sql question for my homework in oracle 11G class [migrated]

as seen on Programmers - Search for 'Programmers'
I am new to oracle 11G programming and i have run into a tough situation with pl\sql funtions and automation. I ame unsure how to create the function for the automation of Registration system for a College registration system. Here is what i want to do. I want to automate the registrations system… >>> More
SQL Server giving a weird conversion error

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello Everyone I'm stuck and any help you can give me is greatly appreciated. create table stackoverflow_rules(myguid uniqueidentifier primary key, myvarchar50 varchar(50)) insert into stackoverflow_rules(myguid, myvarchar50) values('27C4CF31-2C4C-4C78-BBDC-2D0FDAA891CF','9985276') insert into… >>> More
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT

as seen on SQL Authority - Search for 'SQL Authority'
Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options. It is clear that performance of the Insert… >>> More
SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

as seen on SQL Authority - Search for 'SQL Authority'
During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this with all of you and… >>> More
Bulk retrieval in HQL: could not execute native bulk manipulation query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, We are getting a "could not execute native bulk manipulation query" error in HQL When we execute a query which is something like this. String query = "Select person.id from Person person where"; String bindParam = ""; List subLists = getChucnkedList(dd); for(int… >>> More

Related posts about cross-platform

Creating cross platform applications

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a fair bit of knowledge of Java and C#.NET (prefer C#). What should I use to create small applications that will work well in Windows, Mac and Linux? Speed will probably not be the main concern (small applications; using Sockets etc). >>> More
Is there a trend for cross-platform GUI toolkits?

as seen on Programmers - Search for 'Programmers'
What is the trend like for the usage of cross-platform GUI frameworks right now? Are more people starting to use cross-platform frameworks (such as GTK+, Qt and wxWidgets) or are there more who use more platform-tied frameworks (e.g. Cocoa or WPF)? Is it more or less stagnant? Is it like a rollercoaster… >>> More
Appcelerator Set to Release Titanium Cross-Platform App Dev Technology

as seen on Internet.com - Search for 'Internet.com'
The product will Web developers to use languages they already know to build mobile and desktop apps >>> More
Looking for a permissive and active cross-platform image processing library in C/C++

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking a cross-platform image processing library in C/C++ which is under active development. One more requirement: No GPL license. Some references: http://stackoverflow.com/questions/796364/fast-cross-platform-c-c-image-processing-libraries http://stackoverflow.com/questions/1200727/cross-platform-drawing-librar… >>> More
SQLite on C# Cross-Platform Applications

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help/guide me with using SQLite lib on Linux (MONO) and Windows (.NET) On linux i use native mono sqlite client, and on windows i use http://sqlite.phxsoftware.com/ is there a way to define 'using' directives like this : #if (linux) using Mono.Data.Sqlite; #else using System.Data… >>> More