07-15-2009
Ubuntu Bulk Insert to Windows SQLServer
Hi,
Anyone can help me, I can connect from ubuntu "freetds driver" to Windows sqlserver Database and doing select, insert, update, etc.
But when I try to use the Bulk Insert with these command;
1> BULK INSERT test FROM '/home/test/test.txt' WITH (FIRSTROW = 2, CODEPAGE = 'ACP', DATAFILETYPE = 'char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
2> go
Msg 4861, Level 16, State 1, Server GMSERVER, Line 1
Cannot bulk load because the file "/home/test/test.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).
Thanks in Advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi:
How will I execute a Stored Procedure that sits on NT/SQLServer.
Any help would be appreciated.
Thanks (3 Replies)
Discussion started by: mayohan
3 Replies
2. AIX
I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system.
I want this unix application to retrieve data from a SQL server 2000 server to oracle database.
how can i connect to this SQL server database from a unix application
pls help me if you can (2 Replies)
Discussion started by: samsonsimon
2 Replies
3. Shell Programming and Scripting
Hi,
I am doing a migration of Oracle database to SQLSERVER 2005.Mostly my application code is perl scripts and i want to modify the scripts so as to connect to SQLSERVER.
What all would be the changes i have to make for just establishing a connection from Perl script to SQLSERVER... (3 Replies)
Discussion started by: DILEEP410
3 Replies
4. UNIX for Dummies Questions & Answers
hi all..
i need to install RHEL5 on my machine.
m having 15gb of primary partition reserved for this.....
problem is: i have WindowsXP and Ubuntu 8.10 already running ......
XP on first primary and Ubuntu on logical.
Please help me installing RHEL5 without disturbing XP... (0 Replies)
Discussion started by: AVINAZZ
0 Replies
5. UNIX for Dummies Questions & Answers
I am sure this is simple to do but as a newbie to UNIX i don't know much.
I have Ubuntu installed on my machine alongside windows 7.
How do i access all the folders, files and more importantly programs and softwares installed on Windows so i can use them in Ubuntu instead of going back and... (1 Reply)
Discussion started by: pipsonian
1 Replies
6. Windows & DOS: Issues & Discussions
Hello,
How can I please have a program automatically upload some files from a ubuntu server to my machine desktop that is running windows XP? I would like to be able to do that from the windows machine itself.
Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies
7. Debian
HI ! all
I have some model which works fine in windows 7 OS with matlab program I want to run all those from Ubuntu 12.04 32-bit OS.
is there any provision to run windows applications? wine I tried, its not working, if any other available kindly explain the usage also
Note : Dual boot ... (5 Replies)
Discussion started by: Akshay Hegde
5 Replies
8. Shell Programming and Scripting
hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders.
for example:
MSSQL
SQL SERVER
SQLSERVER
case $q in
a) echo -ne "Work database: "
echo ""
echo " 1) ORACLE"
echo... (4 Replies)
Discussion started by: gsflash80
4 Replies
9. Ubuntu
guys tell me steps to install ubunto of linux kali over
windows 7 (0 Replies)
Discussion started by: Roshan4u
0 Replies
10. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
LEARN ABOUT DEBIAN
app::prove::state::result
App::Prove::State::Result(3pm) User Contributed Perl Documentation App::Prove::State::Result(3pm)
NAME
App::Prove::State::Result - Individual test suite results.
VERSION
Version 3.25
DESCRIPTION
The "prove" command supports a "--state" option that instructs it to store persistent state across runs. This module encapsulates the
results for a single test suite run.
SYNOPSIS
# Re-run failed tests
$ prove --state=fail,save -rbv
METHODS
Class Methods
"new"
my $result = App::Prove::State::Result->new({
generation => $generation,
tests => \%tests,
});
Returns a new "App::Prove::State::Result" instance.
"state_version"
Returns the current version of state storage.
"test_class"
Returns the name of the class used for tracking individual tests. This class should either subclass from "App::Prove::State::Result::Test"
or provide an identical interface.
"generation"
Getter/setter for the "generation" of the test suite run. The first generation is 1 (one) and subsequent generations are 2, 3, etc.
"last_run_time"
Getter/setter for the time of the test suite run.
"tests"
Returns the tests for a given generation. This is a hashref or a hash, depending on context called. The keys to the hash are the individual
test names and the value is a hashref with various interesting values. Each k/v pair might resemble something like this:
't/foo.t' => {
elapsed => '0.0428488254547119',
gen => '7',
last_pass_time => '1219328376.07815',
last_result => '0',
last_run_time => '1219328376.07815',
last_todo => '0',
mtime => '1191708862',
seq => '192',
total_passes => '6',
}
"test"
my $test = $result->test('t/customer/create.t');
Returns an individual "App::Prove::State::Result::Test" instance for the given test name (usually the filename). Will return a new
"App::Prove::State::Result::Test" instance if the name is not found.
"test_names"
Returns an list of test names, sorted by run order.
"remove"
$result->remove($test_name); # remove the test
my $test = $result->test($test_name); # fatal error
Removes a given test from results. This is a no-op if the test name is not found.
"num_tests"
Returns the number of tests for a given test suite result.
"raw"
Returns a hashref of raw results, suitable for serialization by YAML.
perl v5.14.2 2012-06-05 App::Prove::State::Result(3pm)