Integration services is an ETL tool for transferring data from a data source to a taget. It can be used for populating databases and data-warehouses.

There are a lot of...

You shouldn't need an open source ETL tool, SQL 2005 ships with SSIS which is as good as any other ETL tool out there and about as easy to...

You may run into trouble running xp_cmdshell on a production server, quite often this feature is disabled on production for security reasons.

Though it would be a lot easier to schedule...

Back them up and they will truncate.

Thanks, no we don't have another server available that we can use. We have decided to go ahead with a 2008 license to act as a Distributor.

Do you know...

Okay, check the error log of the failed sever and this should give you more of a clue on what is going on

Try using full-qualified Tcp address.

instead of

TCP://MYSERVER:5023

try

TCP://MYSERVER.yourdomain.com:5023

From a quick look it looks like this statement may be casuing you some problems

set rs = conntemp.execute("SELECT SQLStmt, DateEntered FROM SavedSearch WHERE ID=" & SavedSearch)

As you SQLstmnt already...

You can geta copy of SQL refactor from Red-Gate this will upcase all your keywords for you , it works really well.

Because the data that your require is located in seperate tables. So you join them together using primary keys and foreign keys to select the information you need.

this code will get you the lastname as long as it the after the last space in the string.

declare @Name varchar(100)

set @name = 'Stephen Robert Fagan and Judith Mary Fagan'

select...

This could be a number of things..

are you able to connect to the server via SSMS?

Does the server allow remote connections?

Is the SQL browser turned on ?

The sub-query means that for each row in the outer query, sql server needs to search the inner query so you exponentially increase the amount of work sql sever has...

Are you able to ping the server?

Why are you using a sub-query for the first example? this could be why the query is timing out, try writing it like this;

select '12' as Norder, description...