Bulk Insert
-
Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) MYPROBLEM: Cannot bulk load. The file "C:\data.txt" does not exist. Pls Anyone Help Me........
-
Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) MYPROBLEM: Cannot bulk load. The file "C:\data.txt" does not exist. Pls Anyone Help Me........
-
Hemalatha.A.M. wrote:
The file "C:\data.txt" does not exist.
Those 195 countries are listed in a file? I'll bet that the file isn't called "C:\Data.txt"..
I are troll :)
what is it called then? :laugh:
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
what is it called then? :laugh:
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
I dunno Sensei, it didn't say in the error-message :^) Although.. it might be listed in the file "C:\pagefile.sys". Yeah, that's the one he should parse! :cool:
I are troll :)
pagefile is locked :((
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
pagefile is locked :((
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
:laugh:
Luc Pattyn wrote:
pagefile is locked :((
My bad, the file is indeed locked whilst Windows' runs. That's quite easy to patch though, may I kindly suggest these steps; * Put your swapfile on an USB-stick Right-click "My Computer", choose "Properties", Tabpage "Advanced", button "Settings" of the groupbox "Performance", Tabpage "Advanced", button "Change" of the groupbox "Virtual Memory". * Load the textfile into your favorite webbrowser. You can either view it locally, or find a good host for this file, preferably with FTP-access and high uptime. * Minimize the browser, and load a 4 Gb movie on Kiwi's (the bird, not the fruit) into MovieMaker. This might cause the contents of the browser to be swapped to virtual memory. I say might, as one never can be sure whether God is or isn't addicted to playing dice. * Yank out the USB-stick as quickly as you can, so that only a minimum amount of bits will spill out of the USB-port. You now have a crashed Windows-system and a pagefile on USB-disk. * Reinstall Windows, and when done, run chkdsk.exe on your USB-stick. Pray to Codd, while sacrificing a HP-calculator during the first Googledance. There you have it; a "pagefile.sys", that may or may not contain a complete or partial list in a non-readable format, ready to be
peek'd,poke'd and goes very well with mayonaise :)I are troll :)
-
:laugh:
Luc Pattyn wrote:
pagefile is locked :((
My bad, the file is indeed locked whilst Windows' runs. That's quite easy to patch though, may I kindly suggest these steps; * Put your swapfile on an USB-stick Right-click "My Computer", choose "Properties", Tabpage "Advanced", button "Settings" of the groupbox "Performance", Tabpage "Advanced", button "Change" of the groupbox "Virtual Memory". * Load the textfile into your favorite webbrowser. You can either view it locally, or find a good host for this file, preferably with FTP-access and high uptime. * Minimize the browser, and load a 4 Gb movie on Kiwi's (the bird, not the fruit) into MovieMaker. This might cause the contents of the browser to be swapped to virtual memory. I say might, as one never can be sure whether God is or isn't addicted to playing dice. * Yank out the USB-stick as quickly as you can, so that only a minimum amount of bits will spill out of the USB-port. You now have a crashed Windows-system and a pagefile on USB-disk. * Reinstall Windows, and when done, run chkdsk.exe on your USB-stick. Pray to Codd, while sacrificing a HP-calculator during the first Googledance. There you have it; a "pagefile.sys", that may or may not contain a complete or partial list in a non-readable format, ready to be
peek'd,poke'd and goes very well with mayonaise :)I are troll :)
So now I have to order: - a PC with USB (making sure I have a Win install disk) - a USB stick (easily yankable) - a Kiwi movie (any recommendation?) - a set of napkins to clean up spilled bits - an HP calculator [ADDED] No mayonaise; still have some [/ADDED] I think I'd rather spend half an hour looking up countries in Wikipedia and recreating the list myself. Actually I could write a program to do just that... :confused:
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
modified on Monday, April 20, 2009 5:38 PM
-
So now I have to order: - a PC with USB (making sure I have a Win install disk) - a USB stick (easily yankable) - a Kiwi movie (any recommendation?) - a set of napkins to clean up spilled bits - an HP calculator [ADDED] No mayonaise; still have some [/ADDED] I think I'd rather spend half an hour looking up countries in Wikipedia and recreating the list myself. Actually I could write a program to do just that... :confused:
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
modified on Monday, April 20, 2009 5:38 PM
-
Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) MYPROBLEM: Cannot bulk load. The file "C:\data.txt" does not exist. Pls Anyone Help Me........
Highly likely your file is on your local c drive and you are executing the bulkcopy on the server so it is looking at the servers c drive!
Never underestimate the power of human stupidity RAH