..I agree, swap the or for an and....I rewrote the code below and tested it with a positive outcome.

IF EXISTS(SELECT patient.F00069, patient.F00026, patient.F01298, patient.F01299, patient.F01300

FROM patient INNER JOIN

tumor ON patient.UK...

minimum:  they will need at least db_reader and db_writer and own the dts package.  they will not be able to execute the package as a job.  That is a sysadmin role...

you bet, if you need more info or a better example ( I know that's a lot of info thrown at you) let me know.  I have run full relational...

The key is how each are stored.  ROLAP doesn't change the storage source - as it exists in your relational table it is used for queries.  MOLAP makes a...

ROLAP:  refers to a relational database design.  Typical design methodology follows a star schemas for data storage and relation.  Open relational designs allow unlimited scalability by raw db size and...

One quick note:  don't forget to check the permissions for your SQL Server service.  When you execute manually, the package is run under your credentials.  Conversely, when scheduled the package...

There is a great reference for SQL Mail on this site.  Go to search type sql mail and choose the article by Steve Jones for SQL Mail Resources.  Great tips.

One...

I would first reconsider storing your data as a float if you care for very precise number storage.

However, if you have no choice you can try using this hack to...

I would do a quick check on connections for user (and in this case server) privledges.  Easy to forget that through EM everything is executed under your account and not...

You could do this with some type of variable, but I would recommend using IDENTITY for an incremental ID column.

You could place the db in single user mode and then execute. 

alter db command or through enterprise manager.

slip this in front of your create table statement:

declare @TABLENAME varchar(50) 

set @TABLENAME= ?(However you're creating table names)

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[@TABLENAME]') and OBJECTPROPERTY(id,...

sp_help tablename  gives information on tables.

This may not work for you but..

How about putting in a line "On error" that will step to another successful piece of script.

Very simple example:

Function Main()

 'Below is all your code

 On...

I would look into building an error trap within your VB Script routine.  This way it will handle the success or failure of finding the file but not report the...