Sponsored Content
Operating Systems Linux Ubuntu Ubuntu Bulk Insert to Windows SQLServer Post 302334162 by dba_macau on Wednesday 15th of July 2009 02:29:06 AM
Old 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

Stored Procedure on NT/SQLServer

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

connect SQLSERVER from unix

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

connecting to sqlserver from perl

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

Rhel5 with ubuntu and windows xp

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

Accessing my windows Application on Ubuntu

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

Get file on our windows desktop from a ubuntu server

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

How to run windows application in Ubuntu?

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

MSSQL or SQL SERVER or SQLSERVER?

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

Installation??? How to install Ubuntu on windows 7

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

Insert bulk values in DB table using isql

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
App::Prove::State::Result::Test(3pm)			 Perl Programmers Reference Guide		      App::Prove::State::Result::Test(3pm)

NAME
App::Prove::State::Result::Test - Individual test results. VERSION
Version 3.26 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. SYNOPSIS
# Re-run failed tests $ prove --state=fail,save -rbv METHODS
Class Methods "new" Instance Methods "name" The name of the test. Usually a filename. "elapsed" The total elapsed times the test took to run, in seconds from the epoch.. "generation" The number for the "generation" of the test run. The first generation is 1 (one) and subsequent generations are 2, 3, etc. "last_pass_time" The last time the test program passed, in seconds from the epoch. Returns "undef" if the program has never passed. "last_fail_time" The last time the test suite failed, in seconds from the epoch. Returns "undef" if the program has never failed. "mtime" Returns the mtime of the test, in seconds from the epoch. "raw" Returns a hashref of raw test data, suitable for serialization by YAML. "result" Currently, whether or not the test suite passed with no 'problems' (such as TODO passed). "run_time" The total time it took for the test to run, in seconds. If "Time::HiRes" is available, it will have finer granularity. "num_todo" The number of tests with TODO directives. "sequence" The order in which this test was run for the given test suite result. "total_passes" The number of times the test has passed. "total_failures" The number of times the test has failed. "parser" The underlying parser object. This is useful if you need the full information for the test program. perl v5.18.2 2014-01-06 App::Prove::State::Result::Test(3pm)
All times are GMT -4. The time now is 09:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy