|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSIS questionNo 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. 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! -- Show quoteMohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 "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. |
|||||||||||||||||||||||