DTS Import: second

Showing posts with label second. 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.
>>
>>
>
>

Wednesday, March 7, 2012

DTS of data between two tables, same field names but differnt datatypes

I need to migrate data from one sql database to another. The second DB
is a newer version of the "old" database with mostly the same tables
and fieldnames. In order support some reporting queries in the "new"
version I needed to change the datatype of a few fields from varchar to
int(the data stored was integers already as they were lookup tables).

DTS works great except in the cases of about 10 fields which I changed
the datatypes on from varchar to int.

DTS seems to drop the data if the fieldname and datatype are not an
exact match. Is there any way to use DTS and have it copy data from a
field call subsid type varchar to a field call subsid type int?<tdmailbox@.yahoo.com> wrote in message
news:1115388735.044389.231150@.g14g2000cwa.googlegr oups.com...
>I need to migrate data from one sql database to another. The second DB
> is a newer version of the "old" database with mostly the same tables
> and fieldnames. In order support some reporting queries in the "new"
> version I needed to change the datatype of a few fields from varchar to
> int(the data stored was integers already as they were lookup tables).
> DTS works great except in the cases of about 10 fields which I changed
> the datatypes on from varchar to int.
> DTS seems to drop the data if the fieldname and datatype are not an
> exact match. Is there any way to use DTS and have it copy data from a
> field call subsid type varchar to a field call subsid type int?

This should work fine - I tested it quickly on two tables with the same
column name but the source being varchar(10) and the destination int. Using
a Transform Data Task worked correctly, and the mapping was handled
automatically.

I'm not sure what you mean by DTS seems to "drop the data". Perhaps you can
give some more information - your MSSQL version, which type of task you're
using to move the data, the DDL for the tables, any error messages etc.

Simon|||DTS copies all the columns except the ones with datatype changes. My
varchars to ints end up with empty ints in the desitnation table.

SQL 2000, DTS export, no error messages.|||I tested it again with the export wizard (I'd used the package designer
before), and it worked fine. I have no idea why it's not working for
you, unless you have a column transformation of some sort. One other
guess would be that your values are too big for an int, and you've also
set ANSI_WARNINGS OFF, which would ignore the overflow. But since
that's ON for ODBC/OLE DB by default, it's very unlikely.

You could specify a source query instead of a source table and use CAST
to force the conversion:

select col1, col2, cast(col3 as int), col4...
from dbo.SourceTable

Even if that doesn't work, you might get a clue of some sort from an
error. Finally, you could also copy the data into a staging table which
has exactly the same structure as the source table, then use SQL to
check and INSERT the data. Or just INSERT directly, if both databases
are on the same server.

Simon

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

Wednesday, March 7, 2012

DTS of data between two tables, same field names but differnt datatypes

DTS Import

Blog Archive

About Me