sql server dts: Hi ,

while i am trying to run follwoing bulk copy command

set @x =3D 'bcp "select * from '+@SourceDatabase+'..users where =
datediff(day,'''+CAST(@maxDate as varchar(30))+''',created) > 0 and =
UPPER(howmadeaware)<>''EXISTING CLIENT''" queryout =
\\10.0.0.253\D\SQLServerGenerated\output\internet\internet.csv -c =
-S'+@SourceServerName+' -U'+@SourceUsername+' -P'+@SourcePassword+' -t =
**Tab** -r ##@##{CR}{LF} -e =
\\10.0.0.253\D\SQLServerGenerated\output\internet\CopyToFileErr.out'

exec @result=3Dmaster..xp_cmdshell @x

am getting the following error message.

SQLState =3D 08001, NativeError =3D 17
Error =3D [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does =
not exist or access denied.
SQLState =3D 01000, NativeError =3D 53
Warning =3D [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen =
(Connect()).
NULL


Note: This is perfectly working in our local machine. The problem =
occuring at the time of deployment.

It will be appreciable if any body can give solution for this.


Thanks and Regards,

On this server can you connect to the other server ay other way?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


[quoted text, click to view]
Hi ,

while i am trying to run follwoing bulk copy command

set @x = 'bcp "select * from '+@SourceDatabase+'..users where
datediff(day,'''+CAST(@maxDate as varchar(30))+''',created) > 0 and
UPPER(howmadeaware)<>''EXISTING CLIENT''" queryout
\\10.0.0.253\D\SQLServerGenerated\output\internet\internet.csv -c -S'+@SourceServerName+'
-U'+@SourceUsername+' -P'+@SourcePassword+' -t **Tab** -r ##@##{CR}{LF} -e
\\10.0.0.253\D\SQLServerGenerated\output\internet\CopyToFileErr.out'

exec @result=master..xp_cmdshell @x

am getting the following error message.

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
NULL


Note: This is perfectly working in our local machine. The problem occuring
at the time of deployment.

It will be appreciable if any body can give solution for this.


Thanks and Regards,
Pradeep Kumar C

Hi
Yes I am able to connect this server throug both SQL Server Enterprise
manager and Query Analyser.
It is allowing me to import data using DTS also.

thanks and regards,
Pradeep Kumar C


[quoted text, click to view]
\\10.0.0.253\D\SQLServerGenerated\output\internet\internet.csv -c -S'+@Sourc
eServerName+'
[quoted text, click to view]