install dtsrun utility

Hello everybody,

I need to install the dtsrun util on a client who needs to call a dts package. I want to do this without enterprise manager.
We had no problem in the past withWin NT 4 client. Right now, I try to
install this dtsrun utility on a Win2k pro client and when I do regsvr32
dtsffile.dll
The instructions are explained on redist.txt on the sql server CD rom.

I receive each time the message that I can't register the dll.

Can anyone point me in some direction ?

Thanks,

Bjorn

this is the information I found :

INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll

Example: regsvr32 80\Tools\Binn\dtsffile.dll

The sqlunirl.dll file should reside in the system folder (i.e.,
\winnt\system32 or \windows\system).in the Text Box type: regsvr32 d:\YourDir\YourFile

where "d:\YourDir\YourFile" is the full path to the dll's.

Seems like you may have left out the c:\pf\MSQLS\80\...\file.dll

Hope this may help...

To unregister it, type in the text box: regsvr32 /u d:\YourDir\YourFile

NOTE: The full path of the dll must be enclosed as regsvr32 "c:\PF\MSLS\80\your.dll" to succeed.|||Also this file may be used to register dll's by right clicking with the shift key

Install Client Utility only

How do I install Client Utility only in SQL Server 2005 installation?
Thanks.
Hello,
In the Setup program in the Feature Selection option, choose Cleint
components and continue based on the installation wizard.
Thanks
Hari
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:832981C7-7490-4C99-8EB5-06974D867671@.microsoft.com...
> How do I install Client Utility only in SQL Server 2005 installation?
> Thanks.

Install Client Utility only

How do I install Client Utility only in SQL Server 2005 installation?
Thanks.Hello,
In the Setup program in the Feature Selection option, choose Cleint
components and continue based on the installation wizard.
Thanks
Hari
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:832981C7-7490-4C99-8EB5-06974D867671@.microsoft.com...
> How do I install Client Utility only in SQL Server 2005 installation?
> Thanks.

Install Client Utility only

How do I install Client Utility only in SQL Server 2005 installation?
Thanks.Hello,
In the Setup program in the Feature Selection option, choose Cleint
components and continue based on the installation wizard.
Thanks
Hari
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:832981C7-7490-4C99-8EB5-06974D867671@.microsoft.com...
> How do I install Client Utility only in SQL Server 2005 installation?
> Thanks.

inserting text > 65535

hi,
i want to insert text of size > 65535 in a text column of sql-server. I'm presently using mcp command to do this, but this utility doesn't allow these long files, and work well upto 65 kb files.
is there a way out.
thanks in advanceThis error had been noted back in Version 4.2 of SQL, see technet article
BUG: BCP Cannot Copy Text/Image Data > 64K from SQL Server (Q111921) (http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q111921)

Try setting the packet size on BCP (flag -a) to the max which is 65535|||That doesn't work... I set the size 100000. When I inserted small files that were loaded smoothly. But for bigger files it says max packaet size is 65k.

I rephrase my problem again:::::
=====================
I'm working with sql server.
I need to load large xml files in the databse, fragment it into the
tables.
(1) I don't know a way to load file with the help of script that can load
text value of > 65k. I'm presently doing with the help of "mcp" command.
But this has got size limitation. So how do u load big file in some of the
"text" field of a table.
(2) I need to do fragmentation of this file. But I cannot declare text
type variable in the procedure. I am able to parse files of upto 8000
characters, but how do I do it if I have a document > 8000 char stored in
a "text" field. I just don't know how to call sp_xml_preparedocument with
a text attribute. I think u cannot say something like
sp_xml_preparedocument @.idoc out,(select textfield from doctable)
where idoc and textfield are integer and text respectively.