Thanks for your reply -- forced me to re-examine the statement.. It works successfully. I had a type in the 2nd column name I was attempting to update...

I added a UNION of the 2 mutually exclusive conditions..

Select ...

INNER JOIN

INNER JOIN

UNION

Select ...

INNER JOIN

INNER JOIN

and that seems to have resolved my issue....

Does anyone have a good link describing how to create the LOOKUP Task?

Again, I need to populate my Child table FK by joining a Parent table's DESCRIPTION col to my...

Solution: http://sqlblog.com/blogs/andy_leonard/archive/2007/07/22/ssis-design-pattern-dynamic-sql.aspx

SSIS Expressions Using nest Double Quotes

The best way I've found to do this is to write the query as I'd like it to appear,...

Just found it.. as you mentioned, it's on the "source" DATA FLOW component... under Properties look for:

-Custom Properties

-- Access Mode (drop down & select SQL COMMAND -instead of OpenRowSet)

--...

OK -- feeling like a true novice here. When I drill into my Data Flow, I have: 1 SOURCE table --> flowing to 1 TARGET table. ...

thanks Phil.. Question: Where is the 'SQL Command' icon? How would I go about using this method?

I edited my Data Flow and added a Conditional Splite inbetween my Source & Target tables..

Within the Conditional Split Transformation editor, I dragged my PK column name down into...

actually -- got it to work -- thanks for the solution..

tried that.. didn't work.. any other idea's for capturing a DTEXEC output which is run in DOS

Thanks for the quick feedback folks. and Yes, we have DRI implemented. (and for those tables without DRI, that's fine) --

I'm just trying to identify the LOAD SEQUENCE...

My XML did not show in last post.. so Ill break it apart.... to allow for posting:

Configuration ConfiguredType = "Property" Path=" \Package.Variables[User::MyVariableName].Properties[Value]" ValueType="String"

ConfiguredValue>MyServerName / ConfiguredValue

...

Yes.. I see the file in this directory:

C:\Program Files\Microsoft SQL Server\90\DTS\Binn

But w/ Vista and the goofy nature of Aministrator on various directories, I cannot update this file...

(if you...

Regarding OPTION 2 below:

1) Run the Wizard to convert the DTS to SSIS (I tried several and got no errors)

2) Run the existing 2000 DTS packages via SSIS

3) Rewrite the...

Based on this Microsoft KB: http://support.microsoft.com/kb/260414

In fact, you MUST specify a UNIQUE SQL Server Virtual Server name ---

6Q: Can I have multiple instances of SQL Server...