I rolled the following procedure a few years back for the same thing.  I place it in the master database and use the sp_prefix so I can call it from...

In order to use your package variables in the SQL task, you must set them up in the Parameter Mapping page when you are editing the task.

For example, I want to...

Integrity constraints are applied on a single row.  Your definition requires checking multiple rows to determine if a single insert is valid.

Enforcing it would require analyzing the full set of...

<SP Name> is a shortcut that works if it is the only line in a t-sql batch.

EXEC <SP Name> is required when there are multiple lines in the batch.

For a...

You can add a new containter to the end of your package, and place a Script Task in it to do the work.  Below is some basic code (sans error-handling,...

  You're shooting at a moving target.  The total CPU time a process uses is measurable.  But the CPU % usage is a state of something at a particular point in...

Unfortunately, I don't have Oracle installed on a SQL Server I can get to right now, but when I had to go through this in the past, the 'MSDAORA' provider...

If I really had to know whether Customer was a table or a view - and I usually wouldn't - it would not take very long to find out, in...

Why bother with the GROUP BY and HAVING?  A simple WHERE meets your needs here.

SELECT @RetVal = MAX(RevNo) + 1
  FROM dbo.tblRevision
 WHERE DocumentID = @DocumentID

'Joins' in diagrams are actual relations - a.k.a. Foreign Key Constraints.  What you are trying is not an option in database diagrams.

Outer joins are for queries.  If you need to...

Well, this one often falls into the same religious-war category as allowing NULLs in columns; many people don't like to change their ways.  This thread should get rather heated.  Let's see...

Because you aren't performing any aggregate functions (sum(), count(), min(), ...), you don't need to use GROUP BY.  The DISTINCT will take care of it.

Otherwise, you will need to add all...

CALs - either per-seat or per-user - do not count connections.  If a user has a per-user CAL, that user may simultaneously open multiple connections to several per-server-licensed SQL Server services...

I got my paper score reports and vouchers for 71-431, 71-441, and 71-444 over the last two weeks.

I took mine at a Thomson-Prometric center.  People who took them with...

Option #2: T-SQL.  "It's greyed out when I try" sounds like you're trying this in Enterprise Manager.  Fire up Query Analyzer and:

1.  Ensure all the tables you're referencing were created...