Re: BCP/OSQL
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 25 May 2006 12:44:40 +0000 (UTC)
DEva (DEva@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thank you so much. My confusion is removed. Yet still you help required.
1.are there any workarounds to do that ( may be beyond osql)- can bcp
return values back to cmd fie so that I can capture them into a
variable.
Not sure what you mean. You can use BCP to export data to a file. If you
then want to read some that that data into variable in a CMD file you
would have to read the file. Sounds kludgy to me.
2. if i use dts can i run that package easily in command promt( not with
much ramp up)
There is command dtsrun for that purpose, I believe.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: BCP/OSQL
- From: Erland Sommarskog
- Re: BCP/OSQL
- Prev by Date: Re: SQLServer runtime alone
- Next by Date: Re: Validations in bcp format file
- Previous by thread: Re: BCP/OSQL
- Next by thread: Re: Master sys.xp_delete_file not found?
- Index(es):
Relevant Pages
|
