Home All Groups Group Topic Archive Search About
Author
1 Oct 2007 6:25 PM
mscertified
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
gobbledygook.

Author
4 Oct 2007 5:41 AM
Mohit K. Gupta
It's been a while since I created a SSIS package.  But I belive if you
double-click on it it brings up settings information for it.  Hope that
helps.  Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


Show quote
"mscertified" wrote:

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

AddThis Social Bookmark Button