I found it easiest to just declare a variable and set it to the server name (ie. glvServer, string, SQL01).

Keep in mind that when you move the DTS...

Wouldn't the temp table need to be named ##Temp (globalizing it) in order for the the 2nd procedure to see it. #Temp is the localized version.

Matt,

Peace Out!

Use DTS. Set up an output file and use either a table or SQL statment to create the output. If you set it up dynamically you can change...

Not only is 'Select *' not part of the Microsodt best practices, they actually recommend using tablename.fieldname through the entire select statement.

It's one of the recommendations that is listed in...

Found the answer in the "Execute Process Task".

Matt,

Peace Out!

I hope you find an easier solution, but I've always run an update query that updated the value in question to

SUBSTRING(expression, start, length).

Peace Out!

I've been using iceows. It supports compressing to .zip and .ice as well as decompressing from a list of about 25 file types. Check it out at http://www.iceows.com.

Peace...

3 additional suggestions.

1. Add a check that prohibits injected SQL from being run in you where clause. (It's actually a standard in our office now thanks to the...

Much thanks to Chip Pearson in the microsoft.public.scripting.vbscript news group for posting the links to http://www.cpearson.com/zips/xlconsts.zip and

http://www.cpearson.com/zips/xlobjects.zip

The numeric translations for my variables was containted within.

The correct line should...

and to finish the original post.

I receive a syntax error on the 2nd line of the vbscript code.

I've played with it for hours today and am looking for a bit...

The tables are loaded weekly so there's no adding or deleteing records so I should be pretty safe. What happens if the table is dropped and recreated. Does...

My additional searches have pretty much agreed with Andy's recomendation.

Thanks All.

2nd question now. Is there a problem using system tables to return rowcounts instead of doing Select Count(*)...