| Author |
 Topic  |
|
|
alejo46
Yak Posting Veteran
Colombia
82 Posts |
 Posted - 08/22/2012 : 19:37:55
|
good evening
ive got 2 question
can i use the bcp program to extract a portion of table ?
ie bcp.exe "select * from database..table where datestart >=20120801 and datestart <=20120820" queryout "c:\nw_table.txt" –n –T
2. or can i use the bulk copy from DTS and what is much more efficient
to use bcp or bulk copy ?
|
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
|
alejo46
Yak Posting Veteran
Colombia
82 Posts |
Posted - 08/23/2012 : 17:34:21
|
thanks a lot for your support, but i tried this coommand but failed:
bcp "select * from dm1_elite..HECHOS_MOVTO_PREPAGO where hor_proceso >='20120201' and hor_proceso <='20120229'" out "\\datamartsql\Historicos\HECHOS_MOVTO_PREPAGO_20120201_20120229.txt" -c -t"|" -Sdatama
the above bcp command yields me an error:
SQLState = 37000, NativeError = 4060
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
requested in login 'select * from dm1_elite'. Login fails.
its likely to be an autentication problem, so i suppose before running this query ive got to create a DB conexion ? right ?
so in new with DTS and i dont the conexion command like for authentication.
thanks for your help in advanced
rtsql -T
|
 |
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
|
alejo46
Yak Posting Veteran
Colombia
82 Posts |
Posted - 08/24/2012 : 21:20:49
|
I already added the swith -T without success yielding the same error.
bcp "select * from dm1_elite.dbo.HECHOS_MOVTO_PREPAGO where hor_proceso >='20120201' and hor_proceso <='20120229'"
out "\\datamartsql\Historicos\HECHOS_MOVTO_PREPAGO_20120201_20120229.txt" -c -t"|" -Sdatamartsql -T
what did i do wrong ? - thanks in advanced |
|
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
|
alejo46
Yak Posting Veteran
Colombia
82 Posts |
Posted - 08/25/2012 : 19:37:42
|
OK you're right, i corrected the query replacing the parameter out with queryout, i tested it and it worked fine for me
Thanks a lot for your support and your help |
|
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
| |
Topic |
|
bcp or DTS tools to extract some data from a table
