DTS Import: installed

Showing posts with label installed. Show all posts

Sunday, March 25, 2012

Dts problem with dual installation of sql 2000 and 2005 on same box

I have Sql 2000 installed first, and a second install of Sql2005 installed
as an instance on the same win 2003 server.
Dts 2000 designer is raising errors on initialisation. When you attempt to
create a new package there are no icons in the connections toolbox.
I am sure this is being cased by the dual server installation, but is there
is a known workaround to get both versions working correctly on the same
box.
Colin RobinsonHi Colin
This does not mention the DTS designer
http://www.aspfaq.com/sql2005/show.asp?id=4 but it could be something
similar.
John
"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
news:O%23VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have Sql 2000 installed first, and a second install of Sql2005 installed
>as an instance on the same win 2003 server.
> Dts 2000 designer is raising errors on initialisation. When you attempt to
> create a new package there are no icons in the connections toolbox.
> I am sure this is being cased by the dual server installation, but is
> there is a known workaround to get both versions working correctly on the
> same box.
> Colin Robinson
>|||Hello Colin,
Also, you may want to reinstall SQL 2000 client tool to see if it helps.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "John Bell" <jbellnewsposts@.hotmail.com>
>References: <O#VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl>
>Subject: Re: Dts problem with dual installation of sql 2000 and 2005 on
same box
>Date: Sat, 11 Feb 2006 16:44:44 -0000
>Lines: 25
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>X-RFC2646: Format=Flowed; Response
>Message-ID: <#d#w3pyLGHA.2300@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 82-69-206-222.dsl.in-addr.zen.co.uk 82.69.206.222
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420781
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Colin
>This does not mention the DTS designer
>http://www.aspfaq.com/sql2005/show.asp?id=4 but it could be something
>similar.
>John
>"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
>news:O%23VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl...
>>I have Sql 2000 installed first, and a second install of Sql2005
installed
>>as an instance on the same win 2003 server.
>> Dts 2000 designer is raising errors on initialisation. When you attempt
to
>> create a new package there are no icons in the connections toolbox.
>> I am sure this is being cased by the dual server installation, but is
>> there is a known workaround to get both versions working correctly on
the
>> same box.
>> Colin Robinson
>>
>
>|||Cheers,
Ended up going back to sql2000 after uninstalling 2005.
I really need both operational at any time (i'm a contract DBA) so it was
back to 2000 in this instance. Im working on a new laptop (dell inspiron
9300, 2.0GB Centrino with 2gb ram) running win2003 server.
I tried running sql2005 on a virtual server 2005 but it was unusuable with
1gb assigned to the virtual pc, so i had to abandon that route.
Only option now is sql2005 on a dual boot (i thought we had got past this
requirement) unless you know better?
The server OS allows me to install server dependancies, It appears a
centrino Mobile processor was not the best choice for the background
processing this config needs
Colin Robinson
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:GbRf0oEMGHA.608@.TK2MSFTNGXA01.phx.gbl...
> Hello Colin,
> Also, you may want to reinstall SQL 2000 client tool to see if it helps.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "John Bell" <jbellnewsposts@.hotmail.com>
>>References: <O#VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl>
>>Subject: Re: Dts problem with dual installation of sql 2000 and 2005 on
> same box
>>Date: Sat, 11 Feb 2006 16:44:44 -0000
>>Lines: 25
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>>X-RFC2646: Format=Flowed; Response
>>Message-ID: <#d#w3pyLGHA.2300@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 82-69-206-222.dsl.in-addr.zen.co.uk 82.69.206.222
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420781
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi Colin
>>This does not mention the DTS designer
>>http://www.aspfaq.com/sql2005/show.asp?id=4 but it could be something
>>similar.
>>John
>>"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
>>news:O%23VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl...
>>I have Sql 2000 installed first, and a second install of Sql2005
> installed
>>as an instance on the same win 2003 server.
>> Dts 2000 designer is raising errors on initialisation. When you attempt
> to
>> create a new package there are no icons in the connections toolbox.
>> I am sure this is being cased by the dual server installation, but is
>> there is a known workaround to get both versions working correctly on
> the
>> same box.
>> Colin Robinson
>>
>>
>|||Hi Colin
I worked with all the 2005 betas on Windows 2003 VPCs with a laptop that had
a similar spec and it performed fine so your results are puzzling.
John
"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
news:uf3hNZNNGHA.536@.TK2MSFTNGP09.phx.gbl...
> Cheers,
> Ended up going back to sql2000 after uninstalling 2005.
> I really need both operational at any time (i'm a contract DBA) so it was
> back to 2000 in this instance. Im working on a new laptop (dell inspiron
> 9300, 2.0GB Centrino with 2gb ram) running win2003 server.
> I tried running sql2005 on a virtual server 2005 but it was unusuable with
> 1gb assigned to the virtual pc, so i had to abandon that route.
> Only option now is sql2005 on a dual boot (i thought we had got past
> this requirement) unless you know better?
> The server OS allows me to install server dependancies, It appears a
> centrino Mobile processor was not the best choice for the background
> processing this config needs
>
> Colin Robinson
>
> "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> news:GbRf0oEMGHA.608@.TK2MSFTNGXA01.phx.gbl...
>> Hello Colin,
>> Also, you may want to reinstall SQL 2000 client tool to see if it helps.
>> Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "John Bell" <jbellnewsposts@.hotmail.com>
>>References: <O#VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl>
>>Subject: Re: Dts problem with dual installation of sql 2000 and 2005 on
>> same box
>>Date: Sat, 11 Feb 2006 16:44:44 -0000
>>Lines: 25
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>>X-RFC2646: Format=Flowed; Response
>>Message-ID: <#d#w3pyLGHA.2300@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 82-69-206-222.dsl.in-addr.zen.co.uk 82.69.206.222
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420781
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi Colin
>>This does not mention the DTS designer
>>http://www.aspfaq.com/sql2005/show.asp?id=4 but it could be something
>>similar.
>>John
>>"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
>>news:O%23VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl...
>>I have Sql 2000 installed first, and a second install of Sql2005
>> installed
>>as an instance on the same win 2003 server.
>> Dts 2000 designer is raising errors on initialisation. When you attempt
>> to
>> create a new package there are no icons in the connections toolbox.
>> I am sure this is being cased by the dual server installation, but is
>> there is a known workaround to get both versions working correctly on
>> the
>> same box.
>> Colin Robinson
>>
>>
>>
>|||Hello Colin,
I installed both SQL 2000 and 2005 on the same machine without this
problem. Also, I found similar issue was resolved by applying SQL server
2000 SP4. You may want try this to see if it is helpful.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Didnt try SP4 never got quite that far.
It all set up ok. It was when you started to use them to mimic an
installation that the problems started. ie network the servers and talk
across them.
for example main server win 2003| sql2000 IIS running web services against
the db , viz studio on it for development.
Biztalk server on virtual pc with Sql2005 This also forced viz studio
installation on same virtual server for dev against the biztalk objects
(Required by biztalk installation in error I beleive)
Win xp installation To Virtual pc to get stuf working that required XP for
installation (drivers wLan bluetooth devices etc)
Then i needed DTS to ETL some stuff from Sql200 - to sql 2005 (or ssis setup
to pull which wwould have been nice ) and Thats when the Config started to
get confused about what versions of "Stuff" was where and as youve
suggested, before i knew it, I was in a new version of DLL hell. with its
obvious installation order requirements.
AS biztalk was the only remaining beta in the bunch it is easy to blame it
for my problems. Although Icant discount plain old horsepower, or a recent
version of virtual pc for 2003!
The only real way to set up this stuff seems to be a few interconnected
laptops! and remote desktop (Which coincidentally appears to have been the
setup used at launch tour!)
Colin Robinson(DBA Development)
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:TANevjeNGHA.768@.TK2MSFTNGXA01.phx.gbl...
> Hello Colin,
> I installed both SQL 2000 and 2005 on the same machine without this
> problem. Also, I found similar issue was resolved by applying SQL server
> 2000 SP4. You may want try this to see if it is helpful.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||and a copy of ghost that works on win2003 with virtual machines that could
backup and restore this lot wouldnt go amiss
Colin
"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
news:etzvVK3PGHA.5296@.TK2MSFTNGP09.phx.gbl...
> Didnt try SP4 never got quite that far.
> It all set up ok. It was when you started to use them to mimic an
> installation that the problems started. ie network the servers and talk
> across them.
> for example main server win 2003| sql2000 IIS running web services against
> the db , viz studio on it for development.
> Biztalk server on virtual pc with Sql2005 This also forced viz studio
> installation on same virtual server for dev against the biztalk objects
> (Required by biztalk installation in error I beleive)
> Win xp installation To Virtual pc to get stuf working that required XP for
> installation (drivers wLan bluetooth devices etc)
> Then i needed DTS to ETL some stuff from Sql200 - to sql 2005 (or ssis
> setup to pull which wwould have been nice ) and Thats when the Config
> started to get confused about what versions of "Stuff" was where and as
> youve suggested, before i knew it, I was in a new version of DLL hell.
> with its obvious installation order requirements.
> AS biztalk was the only remaining beta in the bunch it is easy to blame it
> for my problems. Although Icant discount plain old horsepower, or a recent
> version of virtual pc for 2003!
> The only real way to set up this stuff seems to be a few interconnected
> laptops! and remote desktop (Which coincidentally appears to have been the
> setup used at launch tour!)
>
> Colin Robinson(DBA Development)
>
>
>
> "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> news:TANevjeNGHA.768@.TK2MSFTNGXA01.phx.gbl...
>> Hello Colin,
>> I installed both SQL 2000 and 2005 on the same machine without this
>> problem. Also, I found similar issue was resolved by applying SQL server
>> 2000 SP4. You may want try this to see if it is helpful.
>> Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||Hello Colin,
Thanks for sharing yoru experience on this issue and this shall benefit the
community.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Colin Robinson" <ColinRobinson@.newsgroups.nospam>
>References: <O#VU7ByLGHA.344@.TK2MSFTNGP11.phx.gbl>
<#d#w3pyLGHA.2300@.TK2MSFTNGP15.phx.gbl>
<GbRf0oEMGHA.608@.TK2MSFTNGXA01.phx.gbl>
<uf3hNZNNGHA.536@.TK2MSFTNGP09.phx.gbl>
<TANevjeNGHA.768@.TK2MSFTNGXA01.phx.gbl>
<etzvVK3PGHA.5296@.TK2MSFTNGP09.phx.gbl>
>Subject: Re: Dts problem with dual installation of sql 2000 and 2005 on
same box
>Date: Sat, 4 Mar 2006 05:43:21 -0800
>Lines: 71
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>X-RFC2646: Format=Flowed; Response
>Message-ID: <ecZRgE5PGHA.964@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: cpc2-nott3-6-0-cust27.nott.cable.ntl.com 81.102.243.27
>Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:423266
>X-Tomcat-NG: microsoft.public.sqlserver.server
>and a copy of ghost that works on win2003 with virtual machines that could
>backup and restore this lot wouldnt go amiss
>Colin
>"Colin Robinson" <ColinRobinson@.newsgroups.nospam> wrote in message
>news:etzvVK3PGHA.5296@.TK2MSFTNGP09.phx.gbl...
>> Didnt try SP4 never got quite that far.
>> It all set up ok. It was when you started to use them to mimic an
>> installation that the problems started. ie network the servers and talk
>> across them.
>> for example main server win 2003| sql2000 IIS running web services
against
>> the db , viz studio on it for development.
>> Biztalk server on virtual pc with Sql2005 This also forced viz studio
>> installation on same virtual server for dev against the biztalk objects
>> (Required by biztalk installation in error I beleive)
>> Win xp installation To Virtual pc to get stuf working that required XP
for
>> installation (drivers wLan bluetooth devices etc)
>> Then i needed DTS to ETL some stuff from Sql200 - to sql 2005 (or ssis
>> setup to pull which wwould have been nice ) and Thats when the Config
>> started to get confused about what versions of "Stuff" was where and as
>> youve suggested, before i knew it, I was in a new version of DLL hell.
>> with its obvious installation order requirements.
>> AS biztalk was the only remaining beta in the bunch it is easy to blame
it
>> for my problems. Although Icant discount plain old horsepower, or a
recent
>> version of virtual pc for 2003!
>> The only real way to set up this stuff seems to be a few interconnected
>> laptops! and remote desktop (Which coincidentally appears to have been
the
>> setup used at launch tour!)
>>
>> Colin Robinson(DBA Development)
>>
>>
>>
>> "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>> news:TANevjeNGHA.768@.TK2MSFTNGXA01.phx.gbl...
>> Hello Colin,
>> I installed both SQL 2000 and 2005 on the same machine without this
>> problem. Also, I found similar issue was resolved by applying SQL server
>> 2000 SP4. You may want try this to see if it is helpful.
>> Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>
>

DTS Pkg Job error

I recently installed a new SQL Server and am having problems scheduling my DTS packages. They will work fine if I manually execute them, but none of them will fire from a job.

Regardless of the DTS package scheduled it fails with the following error:

Executed as user: STANDREWS\SYSTEM. The process could not be created for step 1
 of job 0x8D49E4684F14CB49BFC9223F4E47FC16 (reason: The system cannot find the file
specified). The step failed.

I have tried all kinds of stuff to no avail.What does step 1 look like? Did you try specifying the entire path for dtsrun.exe?

Terri|||when they fire from a job, they are firing under the security context of the account that the SQL Agent uses.

Therefore i would conclude that your account has access to something that the SQL Agent account does not.

you could set the SQL Agent to use a specific machine account...|||Yeah, created the job in various fashions, by name, by GUID, etc, etc. I am not certain of the absolute file path though, where is that found?

I will also check the SQL Agent security.|||The absolute file path is the physical path to dtsrun.exe on the SQL Server. On my local SQL Server, e.g., it can be found here: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe

I am bringing this up because I have come across this problem in the past.KB 322746 - PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found addresses this.

Terrisql sql

Thursday, March 22, 2012

DTS Packages in SSIS

I read in Kirk Haselden's book "Microsoft SQL Server 2005 Integration Services" that if SQL Serfver 2005 and 2000 are installed on the same machine as seperate instances then you can view the SQL Server 2000 DTS packages in 2005 Management Studio under the Management tree, Legacy, Data Transformation Services node.

But in my case, I am not able to see DTS packages in Management Studio. Is there a property or a setting that we need to configure for that?

Thanks.

Can you find the node for Data Transformation Services? If so, why can you not see anything, or perhaps what do you see? Have you got any DTS packages on that server, to show in SSMS?

|||Yes, I can see the node for Data Transformation Services but nothing underneath it, even when I refresh it.

DTS Packages in SSIS

But in my case, I am not able to see DTS packages in Management Studio. Is there a property or a setting that we need to configure for that?

Thanks.

Can you find the node for Data Transformation Services? If so, why can you not see anything, or perhaps what do you see? Have you got any DTS packages on that server, to show in SSMS?

|||Yes, I can see the node for Data Transformation Services but nothing underneath it, even when I refresh it.

DTS Packages in SQL 2005 - what are they now, etc

OK - so it looks like DTS Packages are "legacy". I installed the component to be able to edit and run them from SQL 2005 Management console and that seems to work fine. (I haven't acually run my packages yet, but at least I can open and edit the dang things). And I also migrated the existing ones from the networked server on which they lived (which is still running SQL 2000) to my local server (which is the one on 2005).

So assuming I want to do the new methodology - what IS the new methodology?

Where are the migrated packages? I looked at all of the links in the SQL Management Console for anything that references these newly migrate packages, and I don't see them - or anything that looks like them - anywhere.

What do I run them in - from what, how, etc? This really isn't clear at all.OK - so I think I have this figured out. You have to connect to Integration Services for a specific server. If you do that, they are then in the Stored Packages. So I'll post back if I have any problems when I actually get up the courage to try and run these puppies...|||That's correct. If you used the destination as a server, you have to connect to Integration Services and then see the packages under MSDB in stored packages. Alternatively, you can choose "DTSX File" as the destination for your migrated packages, and then save your packages as .dtsx files in your chosen folder. You can then add these packages to an SSIS Project and view/edit them in BI Studio.|||Hi.
Yeah, they are unregular XML-files, I guess. Not to be edited.

Try to enable and start the "DTS Server" service, then run
cmd
dtexec.exe /?

They can also be scheduled from within managment studio and run from bi studio.

Wednesday, March 7, 2012

DTS not connecting to oracle

It tells me client for Oracle not installed. I found an installation of the
client but it's 200MB!!! Is this really it?!!
tia
ZarkoYou need to install Oracle ODBC connectivity on the box(es) that connect to
Oracle. I think it is called SQL *NET ?
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"®arko Jovanoviæ" <zarko.jovanovic_protiv_spama_@.fina.hr> wrote in message
news:1071583104.91341@.internet.fina.hr...
> It tells me client for Oracle not installed. I found an installation of
the
> client but it's 200MB!!! Is this really it?!!
> tia
> Zarko
>|||reinstall oracle client and make sure you can TNSPING the oracle server you want to connect to...
tnsping servername
>--Original Message--
>You need to install Oracle ODBC connectivity on the box
(es) that connect to
>Oracle. I think it is called SQL *NET ?
>-- >--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"=AEarko Jovanovi=E6" <zarko.jovanovic_protiv_spama_@.fina.hr> wrote in message
>news:1071583104.91341@.internet.fina.hr...
>> It tells me client for Oracle not installed. I found an installation of
>the
>> client but it's 200MB!!! Is this really it?!!
>> tia
>> Zarko
>>
>
>.
>

Sunday, February 26, 2012

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

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

(\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!

Sunday, February 19, 2012

DTS in SQL 2005

Hello,

This is kind of a stupid problem. I just installed SQL 2005 Standard and I am trying to use DTS to transform a Access DB to SQL. I am having a tough time finding where that feature is. Is it by default insatlled or is it an add-on?

Thanks!

In SQL 2005 it is no longer called DTS it is known as SSIS(SQL Server Integration Services). You can migrate DTS packages to SSIS or re-build them using the Business Intelligence Development Studio.|||

Thanks!

So does SSIS transform a mdb file the same as the DTS did in 2000?

|||

I have never transformed an mdb file; however, I am assuming it should work. Within the BI Development Studio tool, when you create an SSIS package there is a task that allows you to run SQL 2000 DTS packages. You might be able to get away with creating a one 'step/task' SSIS package that basically runs your SQL 2000 DTS package.

I used the migration wizard in the BI tool to 'convert' my DTS to SSIS and it worked fine; however, mine does not deal with mdb's. My package basically is a SQL statement as the source(in SQL 2005) and 'pushes' the results to a destination table in a SQL 2000 database.

P.S. My DTS was a simple task on the surface, but to migrate to SSIS and then test it as well as understand the new SSIS and BI tool and figure out how to run the package, etc. probably took me a week. Maybe I am not that good at it or I took the long road, but to move(and then understand) from DTS to SSIS is not a trivial half-hour job.

|||

Thanks for the imput. He is my deal. I am new to SQL. I had a evalution version of 2000, and I literally had the MDB file converted into an SQL DB in 5 minutes with DTS. So, once I was ready to purchase and install the full SQL product, I figured that I should go with 2005. Everyone I spoke with said it was way more user friendly!! I still think it probably is, but it certainly is not as easy as the 2000 was.

I am getting stuck alot with my new project, but I am still really enjoying the hands on erxperience dealing with this new technology.

-Mac

|||

You probably used the Import Wizard to do that in SQL Server Enterprise Manager 2000. Have you tried the same in SQL Server Managment Studio 2005? I just did and it took about 20 seconds.

-Jamie

|||

Any luck!

Sounds like what you are trying to do is convert an MDB database to a SQL 2005 database. If this is just a one-ime deal then you can probably get this done as fast as Jamie states.

I assumed you were wanting to move data from MDB to SQL 2005 on a regularly scheduled basis. This too can be simple; however, I feel to truly understand SSIS and its power it may take more than just a one-time 20 second migration. That was my point of my previous post. Each time I 'play' with SSIS I learn something new. It si an on-going educational experience for me.

Swit

|||

Thanks for the reply. I am not trying to import data into SQL on an ongoing basis. I am trying to upgrade our company from an MS Access DB and front-end to ande SQL DB with an ASP.NET website. So what I am trying to do is have SQL import all of the tables and columns and the data and create its own DB from it.

For that reason, the DTS in 2000 was great. I did it just to play with it and it instantly created to DB for me. So now instead of trying to figure out this SSIS in 205, I think I will use the DTS in 2000 and them import it into 2005.

Any feedback?

-Mac

|||

Well, its really up to whats best for you now. SSIS is a much more robust application/platform than DTS was. However as this is a one time operation, your familiar with DTS, and perhaps your short on time, do what you have to do...and enjoy reading about all the great SSIS features later :)

When you get a chance you might want to look at the many webcasts there are for SSIS as a way to ramp up. http://msdn.microsoft.com/SQL/bi/integration/default.aspx

Also, you might explore an option inside Microsoft Access. The upsizing Wizard, which is specifically desinged to move your Access data to SQL. In the Access 2003 menues you would get it from here Tools>>Database Utilities>>Upsizing Wizard

Hope that helps

|||

Thanks for the reply. I am in the process of using the "Upsizing" wizard to convert to the SQL. It is exactly what I was looking for.

-Mac

Sunday, March 25, 2012

Dts problem with dual installation of sql 2000 and 2005 on same box

Dts problem with dual installation of sql 2000 and 2005 on same box

Dts problem with dual installation of sql 2000 and 2005 on same box

DTS Pkg Job error

Thursday, March 22, 2012

DTS Packages in SSIS

DTS Packages in SSIS

DTS Packages in SQL 2005 - what are they now, etc

Wednesday, March 7, 2012

DTS not connecting to oracle

Sunday, February 26, 2012

DTS MAPI profile

DTS MAPI profile

DTS Mail task breaks after SQL 2005 uninstall/install

DTS Mail task breaks after SQL 2005 uninstall/install

DTS Mail task breaks after SQL 2005 uninstall/install

Sunday, February 19, 2012

DTS in SQL 2005

DTS Import

Blog Archive

About Me