How to load a DTS package using SQL Query Analyzer (SQL Server 2000)

I have a fully functional DTS Package that I want to load into a new database environment using SQL Query Analyzer. Does anyone know how to accomplish this task? I know this can be done using Enterprise manager, but I must have it in a script that can be executed in Query Analyzer. Please advice. Thanks.

Why must this be done in Query Analyzer? If the two servers have the ability to connect to each other, you could use sysdtspackages but I don't believe this is the supported option as you are using undocumented system tables. However, you can find information on using this table to move the package in this article: http://www.sqldts.com/204.aspx

Other methods of moving packages are discussed in the article as well. If this is a requirement to move something to production or follow some other promotion or release guidelines, you may want to try to pursue saving the package as a structured storage files. The article addresses how to do this as well. And this method would be supported.

-Sue

How to list atributes of all tables in Query Analyzer

Hi newsgroup
I need to know the properties of all tables in a given database on MSSQL
7.0. I know that there is a stored procedure with the name "sp_MShelpcolumns"
as well as another one called "sp_MSforeachtable". How can I combine these
two to get a result that looks like: tablename, columnname, datatype, size.
The result is something that I would like to copy and paste in Excel to send
it to a business analyst.
Any input is highly appreciated.
Kind regards
Gabriel
You want this ?
select table_name,column_name,Data_type,Character_maximum _length from
information_schema.columns
Thanks
"Gabriel Martin" <GabrielMartin@.discussions.microsoft.com> wrote in message
news:152308E6-5A4B-486E-9AF1-1735A1158881@.microsoft.com...
> Hi newsgroup
> I need to know the properties of all tables in a given database on MSSQL
> 7.0. I know that there is a stored procedure with the name
"sp_MShelpcolumns"
> as well as another one called "sp_MSforeachtable". How can I combine these
> two to get a result that looks like: tablename, columnname, datatype,
size.
> The result is something that I would like to copy and paste in Excel to
send
> it to a business analyst.
> Any input is highly appreciated.
> Kind regards
> Gabriel

How to know which node connected to

Hi ,
Is ther any way to know which node am connecting to or which node the
cluster is running on .
Can we find out the same from Query Analyzer .
Thanks
ARR
From
http://www.microsoft.com/technet/pro.../failclus.mspx
"From a SQL Server perspective, the node hosting the SQL Server resource
does a looks-alive check every 5 seconds. This is a lightweight check to see
whether the service is running and may succeed even if the instance of SQL
Server is not operational. The IsAlive check is more thorough and involves
running a SELECT @.@.SERVERNAME Transact SQL query against the server to
determine whether the server itself is available to respond to requests; it
does not guarantee that the user databases are up. If this query fails, the
IsAlive check retries five times and then attempts to reconnect to the
instance of SQL Server. If all five retries fail, the SQL Server resource
fails. Depending on the failover threshold configuration of the SQL Server
resource, Windows Clustering will attempt to either restart the resource on
the same node or fail over to another available node. The execution of the
query tolerates a few errors, such as licensing issues or having a paused
instance of SQL Server, but ultimately fails if its threshold is exceeded."
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23G0a6WP4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> Is ther any way to know which node am connecting to or which node the
> cluster is running on .
> Can we find out the same from Query Analyzer .
> Thanks
> ARR
>
|||Thanks for the reply ,
But I want to know a query or some way to know which node is currently
hosting sql services .
select @.@.servername returns instance name not hostname or nodename .
Thanks
ARR
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uP3$9SR4EHA.1524@.TK2MSFTNGP09.phx.gbl...
> From
>
http://www.microsoft.com/technet/pro.../failclus.mspx
> "From a SQL Server perspective, the node hosting the SQL Server resource
> does a looks-alive check every 5 seconds. This is a lightweight check to
see
> whether the service is running and may succeed even if the instance of SQL
> Server is not operational. The IsAlive check is more thorough and involves
> running a SELECT @.@.SERVERNAME Transact SQL query against the server to
> determine whether the server itself is available to respond to requests;
it
> does not guarantee that the user databases are up. If this query fails,
the
> IsAlive check retries five times and then attempts to reconnect to the
> instance of SQL Server. If all five retries fail, the SQL Server resource
> fails. Depending on the failover threshold configuration of the SQL Server
> resource, Windows Clustering will attempt to either restart the resource
on
> the same node or fail over to another available node. The execution of the
> query tolerates a few errors, such as licensing issues or having a paused
> instance of SQL Server, but ultimately fails if its threshold is
exceeded."
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23G0a6WP4EHA.2624@.TK2MSFTNGP11.phx.gbl...
>
|||Here's one way:
If you know the group name of the SQL Server resource,
EXEC xp_cmdshell 'cluster group'
If you know the resource name of the SQL Server resource,
EXEC xp_cmdshell 'cluser resource'
Note that group names and resource names can be arbitrary. In our
enviornments, we follow certain naming conventions, so it's easy to tell
which virtual server is in which group.
Also, note that you may consider using EXEC xp_cmdshell 'hostname'.
Unfortunately, on a clustered instance, this gives you the virtual server
name instead of the hostname of teh node. Similarly, none of the following
will give you the node name:
SERVERPROPERTY('MachineName')
SERVERPROPERTY('InstanceName')
SERVERPROPERTY('ServerName')
@.@.servername
Linchi
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23G0a6WP4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> Is ther any way to know which node am connecting to or which node the
> cluster is running on .
> Can we find out the same from Query Analyzer .
> Thanks
> ARR
>

How to know a Server IP address?

Hi
I read that with the next instruction in the SQL Query Analyzer I can know
the IP address of my actual server:
exec master..xp_cmdshell 'ipconfig'
However, it shows 9 rows with additional information I don't want.
I just want the IP address.
How can I do this?
Thanks
Gonzalo,
PING? but will return 3 rows as well. Possibly xp_regread (undoc in Master
db) to read key containing IP address?
HTH
Jerry
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:u1eJ0p10FHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can know
> the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
>
|||Gonzalo Torres wrote:
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can
> know the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
Insert the output from xp_cmdshell into a temp table and parse it as
needed. Run IPCONFIG from the command prompt with the "/?" parameter for
a list of options that may help you reduce its output.
David Gugick
Quest Software
www.imceda.com
www.quest.com

How to know a Server IP address?

Hi
I read that with the next instruction in the SQL Query Analyzer I can know
the IP address of my actual server:
exec master..xp_cmdshell 'ipconfig'
However, it shows 9 rows with additional information I don't want.
I just want the IP address.
How can I do this?
ThanksGonzalo,
PING? but will return 3 rows as well. Possibly xp_regread (undoc in Master
db) to read key containing IP address?
HTH
Jerry
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:u1eJ0p10FHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can know
> the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
>|||Gonzalo Torres wrote:
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can
> know the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
Insert the output from xp_cmdshell into a temp table and parse it as
needed. Run IPCONFIG from the command prompt with the "/?" parameter for
a list of options that may help you reduce its output.
David Gugick
Quest Software
www.imceda.com
www.quest.com

How to know a Server IP address?

Hi
I read that with the next instruction in the SQL Query Analyzer I can know
the IP address of my actual server:
exec master..xp_cmdshell 'ipconfig'
However, it shows 9 rows with additional information I don't want.
I just want the IP address.
How can I do this?
ThanksGonzalo,
PING? but will return 3 rows as well. Possibly xp_regread (undoc in Master
db) to read key containing IP address?
HTH
Jerry
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:u1eJ0p10FHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can know
> the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
>|||Gonzalo Torres wrote:
> Hi
> I read that with the next instruction in the SQL Query Analyzer I can
> know the IP address of my actual server:
> exec master..xp_cmdshell 'ipconfig'
> However, it shows 9 rows with additional information I don't want.
> I just want the IP address.
> How can I do this?
> Thanks
Insert the output from xp_cmdshell into a temp table and parse it as
needed. Run IPCONFIG from the command prompt with the "/?" parameter for
a list of options that may help you reduce its output.
David Gugick
Quest Software
www.imceda.com
www.quest.com