Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for a
temp file. It would be ideal to get the install path and use that. This DTS
will be installed an mulitple instances so I would like to automate this.Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.

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 DTS packages on development machine

I would like to install the components I need to develop a SSIS custom component. Is there an SDK or install option for just the visual studio components?

There is no seperate redistributable or SDK for SSIS. There is actually an SDK folder that gets installed, normally C:\Program Files\Microsoft SQL Server\90\SDK which has SSIS related assemblies for referencing, but I am not sure which install option gives you this. I suggest you run setup and select "Integration Services" and also "Workstation Components..."

A nice blog post about installing SSIS and some of the options-

Michael Entin's WebLog : Why do I get "product level is insufficient..." error when I run my SSIS package?
(http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx)

install DTS package

Hi guys!

How do you install a DTS package from another server.

I have a .dts file (coming from another SQL Server) and I want to transfer it to another SQL Server?

Please advise.

Thanks!

Assuming this is SQL 2000, in enterprise manager right click on the DTS node and select open package(in 7.0 this is all tasks open package). The package should now be open in the designer, now just save it locally as normal.|||http://www.sqldts.com/204.aspx

Inserting with DTS in IDENTITY table

Hi

I need to insert values from a text-file to a table with a primary key as identity. In the text file I have no idea of the primary key values and i get "foreign key constraint violation" when trying to import null values into the column.

How can I solve the problem? With ordinary insert-statement there is no problem since the table generates identity- key values automatically. Is there a possibility to generate identity values with DTS-import?

Bjrnyes.

you just need to not map anything to the primary key column. In the wizard, you need to hit the transform button and make and under the column mappings make sure ignore is selected. If you are using the DTS desginer, you need to get rid of the mapping on your transform data task under the transformations task.

Inserting Nulls with DTS

I am using a DTS package to copy data from a flat file to a table. I need for fields that are empty to be changed to nulls in the output. I wrote a VB Script to do this, but now it takes about 10 times longer that when I used the Copy transformation. Is there a faster way to do this?

I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?Originally posted by jsneeringer
I am using a DTS package to copy data from a flat file to a table. I need for fields that are empty to be changed to nulls in the output. I wrote a VB Script to do this, but now it takes about 10 times longer that when I used the Copy transformation. Is there a faster way to do this?

I haven't tried the Trim transformation yet. (I'm waiting for my load to finish.) Will that place nulls in the output if a field is empty?

Hi,
1-in your SQL Server Table ( Destination DB) set a default value for the field(s), so when you attemp to insert Null value in that Field, the specified default vale will be insert. ( the way of inserting is not important . It can be DTS!!)

2- you can also write a Instead Of Trigger on your Table For Insert, so process the field value, if it's Null , write empty.

Hope that help you