Mark Forums Read

could not able to check path in BCP OUT

Go Back

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reply

#1

Old

surekari@gmail.com

Posts: n/a

could not able to check path in BCP OUT - 04-24-2008 , 09:46 AM

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#2

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#3

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#4

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#5

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#6

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#7

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#8

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

#9

Old

Tomasz Borawski

Posts: n/a

RE: could not able to check path in BCP OUT - 05-02-2008 , 09:35 AM

@result is process exit code and bcp always return ok.

"surekari (AT) gmail (DOT) com" wrote:

Quote:

Hi,

I'm using this query:

SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' +
'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path +
'BIW_Stage_Dim_DatabaseServer' + '.txt -N -S' + 'EW5038EZ\SQL2005' + '
-U' + 'etllogin' + ' -P' + 'saw001'

EXEC @result = master.dbo.xp_cmdshell @cmd, no_output

Here It is giving success even though if I give not existing path.

How can I rectify this problem?

Thanks in advance..

Suresh

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.