try this:

CREATE TABLE dbo.[rowrule](

RuleID INT NOT NULL IDENTITY(600000,1) PRIMARY KEY

,SalesValue money NULL

,SalesQTY INT NULL

,SalesValueOperand CHAR(2) NULL CHECK...

before i do, can you confirm that the metadata for all the source tables are the same? if not, this solution won't work

what i do is change the lookup table in the drop down to any other table. this gives a warning saying the connection manager attributes have changed and the...

is the software architect looking for documentation on your company's existing SSIS packages?

this gives a basic example of how to use the datareader, plus has links to its properties

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx

Could you give an example of the problems you are getting, plus the sql syntax you are using?

Tom

In your script you are dropping the constraint PK_ptPhysicalExam. Perhaps the constraint that is being dropped is a true primary key and this is what the designer is using...

i need to ask a couple of questions to clarify:

1. you mention you need to get row 2 from ID 1 and row 1 from ID 2. what is...

your constraint PK_ptPhysicalExam on [dbo].[ptPhysicalExam] is just a non-clustered index. It is not set as a unique index or a primary key. Therefore, the foreign key cannot reference...

discovered the problem: even though the MSDB connection was dynamic and pointing to the correct server, the packages were holding on to old connection details. I discovered this when...

i think it could be the fact that you have GO statements in the IF block. The GO effectively ends the batch, so the BEGIN statement doesn't have a...

Do you have access to SSIS? You could manage all of what you require in a single data flow task.

Tom

have you got an example of a rule that may be applied?

Tom

i think you need to give aliases to the static columns (i.e. the columns with NULL or the value 20081213) and these then will become the column names in the...

I think the problem is that the CREATE VIEW statement should be the first line in the batch. If you remove the second if statement (which is unnecessary anyway...