Thanks for the suggestion.  It worked pretty well.  I have a question about the use of CTEs.  Does it only get the data requested through the join or does it run...

Let me provide a few more details...

I need to Move data from a SQL 2005 Datawarehouse to a Pervasive.  Pervasive is a flat file database system and falls flat on...

I found a better way to add 0's to the tableID

Using derived column task, I add a new column with the following expression.

RIGHT("0000", 5 - (LEN(TableID))) + TableID

Thanks for the suggestion.  Fortunately, I was able to find a way to do this using a derived column task and expression.

Example:

Column    Action               Expression

TableID Replace(tableID)     (len(tableID) == 3 ? "00"...

I like your idea about showing the diagram.  I think I'll add it to my portfolio if I can find it.  I remember seeing a diagram which showed MCTS, 3...

Richard, I appreciate the feedback.  My greatest concern with the new Certification is the misconception about it being is easier to get.  When i first heard about the redesigned certification path,...

Thanks for the reply.  I was able to accomplish the conditional branching by using an empty script task and setting the constraint precedence to Success and @var < 2001 or...

Matt can I trouble you for a copy of the project document?

John

John.Gartman@gmail.com

That's what i was thinking.  I'm going to push for a more specific list of issues and perhaps a profiler...

We use Source Safe to help with versioning.  Basically, I created a master project for each database server and scripted all the objects to get an initial snapshot.  Now, all...

the funny thing is if I create a store procedure in database1 to select table2 from database2 it works, but using a view doesnt.  I guess i need to enable...

I am not able to select from view1.  I get a User does not exist in the database2 error.

I would like it to return '>', the symbol.

Here's a better example of what we are doing.

The only difference in the procedures is in the way @var3 and @var4 are loaded.  If @var3 and...

Sorry Guys.  Here's an example:  The xml output returns the values in the operator column as ansi.  Thanks for your help.

Create

table #tmpTestXML