Can I get the source to the Import Wizard?

Or is someone reading this a Wizard of Wizards. I need a 2nd flavor of import wizard. The one that I would clone out of the existing one would:

Use ASCII not UnicodeUse the copy column control not the Data ConversionThe size of all fields will be 255 not 50.The data type will be varchar.

In my cloned wizard, the goal will be to just get the data loaded.
All other goals will be addressed by the user after the data is in the database.

Do I hear a volunteer?

Thanks,
IanONot sure what you are asking, but why not skip the Import Wizard and build your own package?

Can 2 SQL servers on domain use same port number?

This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new
software onto our domain. They have told us that the 2nd SQL server must us
e a different port number to the 1st SQL server. Is this the case? It make
s no sense to me and is now
causing a problem with another application we wanted to put onto the SQL ser
ver as well. This program has the port address hard coded, and can not be c
hanged which currently means we can't use it. (The 1st server also has a si
milar piece of software on
it which also can't cope with a different port number, so I can't just switc
h them and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by
IP address and then port numbers.
Many thanks
E TaylorYou need different port numbers if you are on the same machine.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new
software onto our domain. They have told us that the 2nd SQL server must
use a different port number to the 1st SQL server. Is this the case? It
makes no sense to me and is now causing a problem with another application
we wanted to put onto the SQL server as well. This program has the port
address hard coded, and can not be changed which currently means we can't
use it. (The 1st server also has a similar piece of software on it which
also can't cope with a different port number, so I can't just switch them
and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by
IP address and then port numbers.
Many thanks
E Taylor|||So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:

> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some ne
w
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went
by
> IP address and then port numbers.
> Many thanks
> E Taylor
>|||Yep.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:

> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some
new
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went
by
> IP address and then port numbers.
> Many thanks
> E Taylor
>|||Thanks - that helps enormously.
Emma
"Tom Moreau" wrote:

> Yep.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
> So if they are on separate servers, they can have the same port number?
> "Tom Moreau" wrote:
>
> new
> by
>

Can 2 SQL servers on domain use same port number?

This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new software onto our domain. They have told us that the 2nd SQL server must use a different port number to the 1st SQL server. Is this the case? It makes no sense to me and is now
causing a problem with another application we wanted to put onto the SQL server as well. This program has the port address hard coded, and can not be changed which currently means we can't use it. (The 1st server also has a similar piece of software on
it which also can't cope with a different port number, so I can't just switch them and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by IP address and then port numbers.
Many thanks
E Taylor
You need different port numbers if you are on the same machine.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new
software onto our domain. They have told us that the 2nd SQL server must
use a different port number to the 1st SQL server. Is this the case? It
makes no sense to me and is now causing a problem with another application
we wanted to put onto the SQL server as well. This program has the port
address hard coded, and can not be changed which currently means we can't
use it. (The 1st server also has a similar piece of software on it which
also can't cope with a different port number, so I can't just switch them
and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by
IP address and then port numbers.
Many thanks
E Taylor
|||So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:

> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some new
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went by
> IP address and then port numbers.
> Many thanks
> E Taylor
>
|||Yep.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:

> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some
new
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went
by
> IP address and then port numbers.
> Many thanks
> E Taylor
>
|||Thanks - that helps enormously.
Emma
"Tom Moreau" wrote:

> Yep.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
> So if they are on separate servers, they can have the same port number?
> "Tom Moreau" wrote:
> new
> by
>

Can 2 SQL servers on domain use same port number?

This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new software onto our domain. They have told us that the 2nd SQL server must use a different port number to the 1st SQL server. Is this the case? It makes no sense to me and is now causing a problem with another application we wanted to put onto the SQL server as well. This program has the port address hard coded, and can not be changed which currently means we can't use it. (The 1st server also has a similar piece of software on it which also can't cope with a different port number, so I can't just switch them and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by IP address and then port numbers.
Many thanks
E TaylorYou need different port numbers if you are on the same machine.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new
software onto our domain. They have told us that the 2nd SQL server must
use a different port number to the 1st SQL server. Is this the case? It
makes no sense to me and is now causing a problem with another application
we wanted to put onto the SQL server as well. This program has the port
address hard coded, and can not be changed which currently means we can't
use it. (The 1st server also has a similar piece of software on it which
also can't cope with a different port number, so I can't just switch them
and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by
IP address and then port numbers.
Many thanks
E Taylor|||Yep.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:
> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some
new
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went
by
> IP address and then port numbers.
> Many thanks
> E Taylor
>