To enable Auto Hide for tool windows:

http://msdn.microsoft.com/en-us/library/z4y0hsax(VS.80).aspx

1.On the Tools menu, click Options.

2.Expand the Environment folder, and then select General.

-- The General, Environment, Options Dialog Box opens.

3.Under Window Layout,...

This link was somewhat helpful:

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

Essentially, you manually setupo your connecion to your Oracle Server & DB.. then generte the XML file using SSIS Designer tools:

- Load the package into the...

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, then copy...

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...