DTS Problem

I'm getting the error message
Server.CreateObject Failed
when running a dts package. Been searching around, it recommended
re-registering the 5 dts*.dll files on the system.
All but one re-registered without a problem, however, the dtswiz.dll file
didn't - I got this error message
"dtswiz.dll was loaded, but the DllRegisterServer entry point was not found.
This file can not be registered."
Thanks for any help.Try removing it from your server, running a reg clean then
putting it back on and registering it.
Peter
"A man is never more truthful than when he acknowledges
himself a liar."
Mark Twain
>--Original Message--
>I'm getting the error message
>Server.CreateObject Failed
>when running a dts package. Been searching around, it
recommended
>re-registering the 5 dts*.dll files on the system.
>All but one re-registered without a problem, however, the
dtswiz.dll file
>didn't - I got this error message
>"dtswiz.dll was loaded, but the DllRegisterServer entry
point was not found.
>This file can not be registered."
>
>Thanks for any help.
>
>
>.
>|||Thanks for getting back to me peter
Been looking for info on running a registry clean - any advice?
Rich
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c49ff0$10833c20$a601280a@.phx.gbl...
> Try removing it from your server, running a reg clean then
> putting it back on and registering it.
> Peter
> "A man is never more truthful than when he acknowledges
> himself a liar."
> Mark Twain
>
>>--Original Message--
>>I'm getting the error message
>>Server.CreateObject Failed
>>when running a dts package. Been searching around, it
> recommended
>>re-registering the 5 dts*.dll files on the system.
>>All but one re-registered without a problem, however, the
> dtswiz.dll file
>>didn't - I got this error message
>>"dtswiz.dll was loaded, but the DllRegisterServer entry
> point was not found.
>>This file can not be registered."
>>
>>Thanks for any help.
>>
>>
>>.

DTS Package: EXCEPTION_ACCESS_VIOLATION when saving

My team is getting this message when altering a DTS Package, using SQL 2000 DTS Designer. We have downloaded all the SQL updates (Backward Compatibility, and the one specifically for DTS Save problems. Have tried this in SQL2005 as well. Have uninstalled both of these programs, and reinstalled on local machines. No avail. Here is what happens:

1) Editing an existing DTS Package, such as a Text Change, or simple connection change

2) Saving the file creates the exact message below:

Package Error

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION

3) Then you have to choose OK in the windows Popup Box.

4) The DTS is brought back to the original screen, or completely exited out of Designer.

5) From that point, the Package can no longer be opened for editing, unless you open a previous version (which means changes aren't saved.

We have also tried to SAVE AS another filename. This doesn't work either.

Our team has close to 75 DTS Packages, some simple, some more complex. We are corrupting these left and right. This problem happens no matter what is created in the DTS Package.

This is running into our business operations, and we are unable to find out a resolution...HELP

Any insight in this would be greatly appreciated.

Thanks,

Jason

The first thing that you need to do is back up msdb (or export sysdtspackages)! Make sure that you have all of your DTS packages available to reopen. I would first try exporting the package records to another server and see if you are getting the same thing. Possibly something has happened on that particular server.

Lee Everest

www.texastoo.com/sqlblog

DTS Package failure

I have a DTS package which keeps failing giving me the error message “A connection with the transaction manager was lost". The DTS package is using two different servers as connection and the DTS package has Use Transaction, Rollback transaction on failure and Join transaction if present ticked. I have checked the MSDTC service is running on both servers, the following options on both servers have been checked; Network DTC Access, Allow Inbound and Outbound. Does anybody know what is causing this error message?

Any suggestions much appreciated.

Regards
AmberThis is no longer a problem as we removed Use Transactions on the DTS package and added additional steps on failure to allow rollback.

DTS Package error: TNS-12541: TNS:no listener

I have created a connection to an Oracle database. I am able to connect to
one server and not to the other. The error message I get is : TNS-12541:
TNS:no listener
Here are the steps I took before creating this connection:
Oracle Client instaled on SQL Server
TNS Names file configured with oracle server and port
Can someone tell me what to do? thanks
James"James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> I have created a connection to an Oracle database. I am able to connect
to
> one server and not to the other. The error message I get is : TNS-12541:
> TNS:no listener
> Here are the steps I took before creating this connection:
> Oracle Client instaled on SQL Server
> TNS Names file configured with oracle server and port
> Can someone tell me what to do? thanks
> James
Your TNSNames file needs to have an entry for each Oracle server that you
wish to connect to along with the appropriate credentials.
HTH
Rick Sawtell|||Rick,
Thank you so so much. I did have the right port in the TNSname file but not
the right host name. As soon as I fixed that credential, it worked fine.
Thanks again.
James
"Rick Sawtell" wrote:

> "James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
> news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> to
> Your TNSNames file needs to have an entry for each Oracle server that you
> wish to connect to along with the appropriate credentials.
> HTH
> Rick Sawtell
>
>

DTS Package error: TNS-12541: TNS:no listener

I have created a connection to an Oracle database. I am able to connect to
one server and not to the other. The error message I get is : TNS-12541:
TNS:no listener
Here are the steps I took before creating this connection:
Oracle Client instaled on SQL Server
TNS Names file configured with oracle server and port
Can someone tell me what to do? thanks
James
"James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> I have created a connection to an Oracle database. I am able to connect
to
> one server and not to the other. The error message I get is : TNS-12541:
> TNS:no listener
> Here are the steps I took before creating this connection:
> Oracle Client instaled on SQL Server
> TNS Names file configured with oracle server and port
> Can someone tell me what to do? thanks
> James
Your TNSNames file needs to have an entry for each Oracle server that you
wish to connect to along with the appropriate credentials.
HTH
Rick Sawtell
|||Rick,
Thank you so so much. I did have the right port in the TNSname file but not
the right host name. As soon as I fixed that credential, it worked fine.
Thanks again.
James
"Rick Sawtell" wrote:

> "James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
> news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> to
> Your TNSNames file needs to have an entry for each Oracle server that you
> wish to connect to along with the appropriate credentials.
> HTH
> Rick Sawtell
>
>

DTS Package error: TNS-12541: TNS:no listener

I have created a connection to an Oracle database. I am able to connect to
one server and not to the other. The error message I get is : TNS-12541:
TNS:no listener
Here are the steps I took before creating this connection:
Oracle Client instaled on SQL Server
TNS Names file configured with oracle server and port
Can someone tell me what to do? thanks
James"James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> I have created a connection to an Oracle database. I am able to connect
to
> one server and not to the other. The error message I get is : TNS-12541:
> TNS:no listener
> Here are the steps I took before creating this connection:
> Oracle Client instaled on SQL Server
> TNS Names file configured with oracle server and port
> Can someone tell me what to do? thanks
> James
Your TNSNames file needs to have an entry for each Oracle server that you
wish to connect to along with the appropriate credentials.
HTH
Rick Sawtell|||Rick,
Thank you so so much. I did have the right port in the TNSname file but not
the right host name. As soon as I fixed that credential, it worked fine.
Thanks again.
James
"Rick Sawtell" wrote:
> "James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
> news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> > I have created a connection to an Oracle database. I am able to connect
> to
> > one server and not to the other. The error message I get is : TNS-12541:
> > TNS:no listener
> >
> > Here are the steps I took before creating this connection:
> >
> > Oracle Client instaled on SQL Server
> > TNS Names file configured with oracle server and port
> >
> > Can someone tell me what to do? thanks
> >
> > James
> Your TNSNames file needs to have an entry for each Oracle server that you
> wish to connect to along with the appropriate credentials.
> HTH
> Rick Sawtell
>
>

DTS Package as a job

I tired to run a DTS package as a job and the job failed right away with the following message in the history of the job.

I'm running the DTS package using the dtsrun cmd in the job.

The error message:

DTSRun: Loading... Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.

W the f_is worng with it.... sorry this is urgentThat means that some object in your dts package has not been registered or is corrupt - Did this package run successfully from the dts designer ?|||Well I have activex scripts, dynamic propeties task, sql tasks in the package. I ran perfect on the development server as a job but on the uat server it gives that error. what r they ways around this?|||Did you copy the package from the development server to this one ? Also, did you try running the package from the dts designer on this server ?|||Originally posted by rnealejr
Did you copy the package from the development server to this one ? Also, did you try running the package from the dts designer on this server ?

Yes i coped the package from dev to uat. no i didnt becuase the pakage is built to be protable ie the connection data sources use (local) so they dont haveto be changed once they r promoted to different enivornments.... so if the package is run from the designer it wont use the uat server but my local server... but if its run as a job it runs on the uat server...|||I would test the package and run it on the actual sql server uat through the dts designer. This will eliminate any issues between the differences in how sql server executes a job versus a dts package.|||Originally posted by rnealejr
I would test the package and run it on the actual sql server uat through the dts designer. This will eliminate any issues between the differences in how sql server executes a job versus a dts package.

I ran the package on the actual server through dts designer and it works fine. but running it as a job still gives me the invalid class string error.

Plz advise.|||Is the owner of the job a sa within sql server ? If it is, what is the login/permissions of the account that is used for the agent service ?|||job owner is sa
login/permissions are administrative rights (all access)

generally what can generate this error?|||This might be related to permissions in the registry. What login is used to run the sql server agent service ? And what permissions does it have on this server ?|||The sql server agent uses system login. I'm guessing the system login has all the rights etc

fyi : it's running SQL7.0, Mdac version 2.5.4403.12

Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86) Sep 6 2002 15:10:15 Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)|||You created the package using SQL 2000 Enterprise manager which has objects like dynamic properties task, that do not exist on SQL 7. You will be able to execute it through enterprise manager on your PC, but not as a job on the SQL 7 Server.|||Thank you!... never realized that

ne alternatives to dynamic task properties in sql7 ?|||Yes, use Active X scripts to assign properties to objects. Like this: Well you'll have to format it better, the small text box messed it up.

Option Explicit
Function Main()

Dim oPKG
Dim oCustomTask

Set oPKG = DTSGlobalVariables.Parent

oPKG.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask.Properties.Item("DestinationObjectName").Value = DTSGlobalVariables("fundingTableName").Value
oPKG.Tasks("DTSTask_DTSDataPumpTask_2").CustomTask.Properties.Item("SourceObjectName").Value = DTSGlobalVariables("tableName").Value
oPKG.Tasks("DTSTask_DTSDataPumpTask_2").CustomTask.Properties.Item("DestinationObjectName").Value = DTSGlobalVariables("exportPath").Value
oPKG.Tasks("DTSTask_DTSDataPumpTask_3").CustomTask.Properties.Item("DestinationObjectName").Value = DTSGlobalVariables("tableName").Value
Set oPKG = Nothing

Main = DTSTaskExecResult_Success
End Function|||Nice catch shicks.|||No Problem, Anytime.|||Say i have to set the data source of a connection using active x... how would i do that?

for eg: the data source of the connection should equal to a global variable.|||This should do it

Function Main()

Dim oPKG
Dim oConnection

Set oPKG = DTSGlobalVariables.Parent

For Each oConnection in oPKG.Connections
If oConnection.ProviderID = "SQLOLEDB" Then
oConnection.DataSource =DTSGlobalVariables("server").Value
oConnection.Catalog = DTSGlobalVariables("database").Value
oConnection.UserID = DTSGlobalVariables("username").Value
oConnection.Password = DTSGlobalVariables("password").Value
End If
Next

Set oConnection = Nothing
Set oPKG = Nothing

Main = DTSTaskExecResult_Success

End Function|||Life saver!
thx

ne good resources where i could learn more about ActiveX scripts?

thx again|||I think it's VB script, then I just open the dynamic properties task and pick and object and get the property names. I am sure there must be a more efficient way to view the DTS classes, but it works for me. Maybe look for a DTS programming book. I don't know of any off the top of my head, but I am sure they are out there.

DTS Migration error message

I get the following error message when attempting to migrate DTS packages from SQL Server 2000 to SQL Server 2005:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)

Could this be it:

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

-Jamie

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:

>I get "Unable to load MAPI profiles" error message in DTS Designer trying t
o
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the sam
e
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:

> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the same
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:
> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
> >add "Send Mail" task.
> >SQLMail has been installed and configured (and tested, it works) on the same
> >server.
> >
> >Please help, thank you in advance
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>> When in the designer, it's using the current users windows
>> account and the current users mail profile from the location
>> or PC where you start up DTS.
>> Are you opening up the designer while logged onto the server
>> using the service account or are you doing this from your
>> PC? If it's from a PC, it doesn't matter what you have setup
>> on the server.
>> -Sue
>> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
>> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>> >add "Send Mail" task.
>> >SQLMail has been installed and configured (and tested, it works) on the same
>> >server.
>> >
>> >Please help, thank you in advance
>>

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -

(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -

SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components

Once I installed this package, I broke SQL Server 2000

completely. Now I can open the DTS package in 2005, but I'm still

getting some buggy issues. And, now when I reinstall SQL Server 2000,

it will not work.

Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.

|||

Ok - I have this working on 2000 and 2005, but I went

through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer

Components, I noticed the \80\Tools\Binn directory had both dll files -

semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000

was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors.

I uninstalled and then reinstalled SQL Server 2000. It still would not work

until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail

issue

When trying to open the send mail task in 2000, I got an

error regarding a missing file-

semmap90.rll (RLL) in this directory. -

C:\Program Files\Microsoft SQL

Server\80\Tools\Binn\Resources\1033

This directory had the semmap.rll file, so I made a copy of

it and then renamed it to semmap90.rll. Now this resources folder has

semmap90.rll and semmap.rll. Both are the same exact files, just different

names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

- There should be two dll files in here (semmap.dll and semmap90.dll).

If you do not rename the original semmap.dll to semmap90.dll, prior to

installing the Microsoft SQL Server 2000 DTS Designer Components, you will only

have one of the files (was able to verify this on another system - 2000 SP4,

2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working.

Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.

I'm running SQL Server 2000, SP4.

This directory needs two DLL's:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

semmap.dll - (version 2000.80.2039.0)

semmap90.dll - (version 2000.80.194.0)

This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033

semmap.rll - (version 2000.80.194.0)

semmap90.rll - (version 2000.80.194.0)
- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -
SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components
Once I installed this package, I broke SQL Server 2000 completely. Now I can open the DTS package in 2005, but I'm still getting some buggy issues. And, now when I reinstall SQL Server 2000, it will not work.
Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.|||

Ok - I have this working on 2000 and 2005, but I went through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer Components, I noticed the \80\Tools\Binn directory had both dll files - semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000 was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors. I uninstalled and then reinstalled SQL Server 2000. It still would not work until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail issue

When trying to open the send mail task in 2000, I got an error regarding a missing file- semmap90.rll (RLL) in this directory. -
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
This directory had the semmap.rll file, so I made a copy of it and then renamed it to semmap90.rll. Now this resources folder has semmap90.rll and semmap.rll. Both are the same exact files, just different names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
- There should be two dll files in here (semmap.dll and semmap90.dll). If you do not rename the original semmap.dll to semmap90.dll, prior to installing the Microsoft SQL Server 2000 DTS Designer Components, you will only have one of the files (was able to verify this on another system - 2000 SP4, 2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working. Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.
I'm running SQL Server 2000, SP4.
This directory needs two DLL's:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
semmap.dll - (version 2000.80.2039.0)
semmap90.dll - (version 2000.80.194.0)
This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
semmap.rll - (version 2000.80.194.0)
semmap90.rll - (version 2000.80.194.0)

- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!

DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back?I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.|||DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1)?|||Go to the 80 directory that's installed with SQL Server 2000 -

(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll|||

I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil

|||I'm messing around with this more and here's what I've found now -

SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components

Once I installed this package, I broke SQL Server 2000

completely. Now I can open the DTS package in 2005, but I'm still

getting some buggy issues. And, now when I reinstall SQL Server 2000,

it will not work.

Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.

|||

Ok - I have this working on 2000 and 2005, but I went

through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer

Components, I noticed the \80\Tools\Binn directory had both dll files -

semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000

was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors.

I uninstalled and then reinstalled SQL Server 2000. It still would not work

until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail

issue

When trying to open the send mail task in 2000, I got an

error regarding a missing file-

semmap90.rll (RLL) in this directory. -

C:\Program Files\Microsoft SQL

Server\80\Tools\Binn\Resources\1033

This directory had the semmap.rll file, so I made a copy of

it and then renamed it to semmap90.rll. Now this resources folder has

semmap90.rll and semmap.rll. Both are the same exact files, just different

names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

- There should be two dll files in here (semmap.dll and semmap90.dll).

If you do not rename the original semmap.dll to semmap90.dll, prior to

installing the Microsoft SQL Server 2000 DTS Designer Components, you will only

have one of the files (was able to verify this on another system - 2000 SP4,

2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working.

Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@.gmail.com

- Dana Rivkind

|||Here's a quick summary of the files and versions I have. Everything still works fine.

I'm running SQL Server 2000, SP4.

This directory needs two DLL's:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

semmap.dll - (version 2000.80.2039.0)

semmap90.dll - (version 2000.80.194.0)

This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033

semmap.rll - (version 2000.80.194.0)

semmap90.rll - (version 2000.80.194.0)
- Dana|||Thanks! Note you want to Copy (not rename) but this did the trick!