|
|
Posted by Roy Harvey on 07/06/07 13:41
You don't need the full set of client tools to run DTS packages, just
the dtsrun.exe utility. And for SSIS packages there is the dtexec
command line utility, though I have not used it. And as Erland said,
for BCP you need bcp.exe.
Roy Harvey
Beacon Falls, CT
On Thu, 05 Jul 2007 21:55:53 -0000, Emin <emin.shopper@gmail.com>
wrote:
>Doesn't the client need something like SQL Management studio installed
>to use DTS or SSIS? Ideally, I'd like something where the client can
>just connect to the database using odbc or ado and do the insert as
>opposed to requiring the client to have special software installed.
>
>Thanks,
>-Emin
>
>On Jul 5, 5:28 pm, Roy Harvey <roy_har...@snet.net> wrote:
>>
>> The Bulk Copy command line utility BCP.EXE is one alternative, as are
>> DTS (SQL Server 2000) and SSIS (2005) executing locally.
>>
>> Roy Harvey
>> Beacon Falls, CT
>
Navigation:
[Reply to this message]
|