[THIN] Re: bcp.exe
- From: Henry Sieff <hsieff@xxxxxxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Wed, 26 Mar 2003 11:29:59 -0600
Sadly, not BCP. What you could do is pipe the variables to a file in the
logon script, and then bcp that file into a table.
BCP (bulk copy) is intended to take large files in a formatted text file and
dump them in.
OSQL.EXE is what you want, but the syntax can be hairy. It is part of the
standard SQL client tools install. Pretty much allows you to submit any
T-SQL you want, uses ODBC to connect.
Henry
> -----Original Message-----
> From: Jason A. Shivok [mailto:jshivok-list@xxxxxxxxxxxxxxx]
> Sent: Tuesday, March 25, 2003 3:00 PM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] bcp.exe
>
>
> Is there anyway to use bcp.exe or any oter similar utility to
> export a set of variables directly into a sql table via a
> logon script? I tried using a % variable with bcp.exe but it
> seems to want an actual file to import from. any clues?
> ********************************************************
> This Week's Sponsor - Emergent Online
> EOL's Universal Printer new Features include:
> Network Printing, Pagestreaming, 2400 DPI.
> No Client Software Required!
> http://www.go-eol.com/
> **********************************************************
>
> For Archives, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> http://thethin.net/citrixlist.cfm
>
********************************************************
This Week's Sponsor - Emergent Online
EOL's Universal Printer new Features include:
Network Printing, Pagestreaming, 2400 DPI.
No Client Software Required!
http://www.go-eol.com/
**********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
Other related posts:
