failed to register dll files needed for DTS

I found the information of installing DTS service without installing SQL server on the disc:

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).

when I attempted to register the dlls, the message
:"loadLibrary("...\dtsffile.dll")failed - The speified module could not be
found.

is there anything I have to do before I can get the dll registered?

Thanks in advance.problem solved, please consult here:

http://www.sqldts.com/default.aspx?6,105,225,0,1

fail an execute sql task

I have a dts package that is essentially three transformation tasks that creates 3 text files. The transform data is accomplished through an sql query. Before I execute the transform tasks I would like to peform a couple of simple existence checks to verify data: i.e,

if exists (select * from table where week_ending = endoflastweek(getdate())

I could put the statement into the sql (if exists, begin/end) of each of the transformation tasks and prevent the process from executing, but it would be easier to put it into an "execute sql task" and if it succeeds, fail the task or make some kind of declaration not to proceed. I'm not sure how to do this...I know this can be done with an activeX script,

Main = DTSTaskExecResult_Failure

Is there a way to do this in an execute sql task step?I am not sure if you are looking for raiserror or return here. Look up both in Books Online, and see what you think. I am leaning raiserror.

FAct TABLE LOOKUPs data

Hi,

Please help me out in loading the fact tables

I had used lookup on DIM table to get my SUK and if I use union transformation to get the out put from each lookup and then loading the data with some condition the data in my fact is not loading in a proper format.

The union transformation is splitting the out put in to different records

Please do inform me about which transformation should be used to get the data from lookup tables.

Or please do inform me the approach to load the fact table in SSIS.

I’m basically INFORMATICA resource and I’m implementing in terms of INFORMATICA

First of all, In SSIS you don't link ports(columns) separately; you link component input and outputs. The Dataflow should look like:

Source Component -->LKP1(get Dim1 SUK) -->LKP2(get Dim2 SUK) -->LKn(getDimn SUK) ...-->Destination Component

Notice you may want to configure the Lookup error output to either redirect or ignore errors as this component treats the no matches as errors.

In the first page of this forum there is a webcast that shows a similar approach:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1

Please post back if something is not clear.

|||

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

|||Instead of a UNION, try connecting the output from Lookup 1 to Lookup 2 directly. If you do that, you don't need a union.|||

Sheikh Mohammed wrote:

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

AS John says, you don't need the UNION all component at all because you have single pipeline; that is the same concept that in Informatica I belive