How to determine if a linked server is available

Hello all,
I need to write data from one SQL server in to a linked server running on an
other machine. How can i check with T-SQL commands if this server is
available?
If it is not available the stored procedure directly quits with an error.
But this procedure should continue in differt ways, depending on the result
of the linked server transaction.
Both servers are MS SQL 2000, SP3a
Thanks a lot.
Try
if exists(select * from master.dbo.sysservers where srvname =
'OtherServer')
BEGIN
-- my code
END
sql

How to determine if a linked server is available

Hello all,
I need to write data from one SQL server in to a linked server running on an
other machine. How can i check with T-SQL commands if this server is
available?
If it is not available the stored procedure directly quits with an error.
But this procedure should continue in differt ways, depending on the result
of the linked server transaction.
Both servers are MS SQL 2000, SP3a
Thanks a lot.Try
if exists(select * from master.dbo.sysservers where srvname =
'OtherServer')
BEGIN
-- my code
END

How to deploy packages to sql server 2005

I'm still getting used to SSIS and I'm wondering how to deploy all 20 of my ssis packages to my sql server 2005 machine in the msdb?

I could open each one and then save a copy as, but by default it doesn't put the name of the package in so I must copy and paste.

thanks.

Any particular reason for using MSDB?

I used it and found it painful for the exact reason you stated.
Now I use the file system with a stand structure for each package.
\Root\
MyPackage
Bin
ConfigFiles
Logfiles
CheckPoint
RawFiles.

Simplier to manage.|||

There are great reasons to use SQL Server for deployment - in particular you can manage security on your packages easily with roles, and you can back up your packages with your databases.

Have a look at http://msdn2.microsoft.com/en-us/library/ms137592.aspx and http://msdn2.microsoft.com/en-us/library/ms137900(SQL.90).aspx (Please rate BOL content by voting and commenting at the foot of each topic.)

However, file system deployment is good too. I suggest researching in BOL and assessing what is best for your business cases.

Donald

|||

After an all nighter 11pm and a few hours today I finally realized that all that I needed to do was select the option to password protect the package. This seems to of worked.

Thanks for all your help Donald.