sql server dts: No idea if this is the right forum for this - could not find an SSIS forum
anywhere.

I'm working with this for the first time and finding it very weird. Nothing
seems to work intuitively. I'm trying to set up a simple package and it is
taking hours. I'm using VS 5.

I have a data flow which is to read data from an MS Access database query.
In my data flow I see a box 'OLE DB source'. I vaguely remember creating this
box but now how do I see what it represents? Clicking it does nothing. No
right click option seems useful. It has a red circle with an 'X' in it which
I assume means something is wrong. How to find out what? The only way I found
to do anything with this box is to create a a new one, no way to examine an
existing one, so now I have dozens of useless connection managers. I have
downloaded reams of MSDN SSIS help files but it is all undecipherable

Hello,

The Red-X does indeed mean that something is wrong. In this case, if you
let your mouse float over it long enough, you'll probably see that its complaining
about "a connection is not defined."

To start defining a connection, right-click on that component and select
"edit."

If you are struggling to get up the SSIS learning curve, you might want to
take a look at Benko's webcast introduction at http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271517&EventCategory=3&culture=en-US&CountryCode=US
(watch for wrapping)

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/