Invalid object / fail to explore data

[JanelleSQL]

Hi


I am newbie in the SQL. I am learning with book called Microsoft SSIS step by step.

I am practicing the sample data supplied with the book. I really need your patience to solve my problem

Q.1) When I open a sample package ‘ createlist’ in the BIDS,
I found yellow triangles in the objects ‘data flow task employee query’ and ‘data flow task scrapped products’ – in the control flow tab.
Then I went to data flow tab I found the red crosses in the OLE DB sources of employee list and OLE DB sources scrapped products’.




When I executed the package,

It says error at data flow task –employee list (OLE DB source –employee query An OLE DB error has occurred: Ox80040E14.
OLE DB record is available; source: Microsoft SQL native client; Hresult: Ox80040E14; Description: statement could not be prepared.
OLE DB record is available, source: Microsoft SQL native client; Hresult: Ox80040E14; invalid object name ‘shift’

It says error at data flow task – scrapped products (OLE DB source – scrapped products An OLE DB error has occurred: Ox80040E14.
OLE DB record is available; source: Microsoft SQL native client; Hresult: Ox80040E14; Description: statement could not be prepared.
OLE DB record is available, source: Microsoft SQL native client; Hresult: Ox80040E14; invalid object name ‘products’




** ‘Shift’ is one of the 3 table and ‘products’ is one of the 5 tables in the dsv of Scrapreason and employee.



I went OLE DB source editors (OLE DB source – scrapped products and OLE DB source –employee query) to fix these.

After checking the server name, data source and successfully test connected, then come to source editor to view the columns, the above mentioned error appeared again respectively and I could not click OK and end up only with cancel button.

And hence I could not remove those yellow triangles and red crosses from the OLE DB source and hence the execution.




Q.2). In the same environment (BIDS), I opened the dsv ‘Scrapreason’, I found a unconnected table – as ‘named query’ titled ‘Scrapped products’. When I right click and went to explore the data- it says invalid object ‘Product’

Since I am new to this field, I could not locate my mistakes exactly though they seem to be basic.

Could any one help me to fix these please.

Scratching my head for the last 3 days.



Thanks

 

[MDXer]

sounds like there is an issue with the underlying database in both cases. even though you can test the connection without issuedo the tables actually exist in the database you are pointing to?
are the tasks you are looking at using the proper connection manager?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[JanelleSQL]

Hi Paul,

Thank you for attention. This is sample database came in the CD with Book MS SQL 2005 SSIS.

When I see the screen shots in the book, those triangels and red crosses are not present.

that means I tempted to think that somewhere I mishandled the procedure.

Even I reloaded the data after erasing the old one. Yet I got this.

That means the problem might not with the data but with my connection to SMS. Bcos these triangles appear in the BIDS few seconds after I opened the pacakge in the BIDS

 

[JanelleSQL]

I try to fis these by going to source editor. But when I click the column in the connection manager - error appears and could not click OK

Thanks, please guide me further.

 

[JanelleSQL]

Hi Paul,

Thanks for your suggestion and questioning the actual existence of the table. I found upon verification those tables were missing in the SMS - database - tables. I found those missing tables in the my documents along with others as mdf files and asking me to manually attach. I did not do this previously since they did not mention in the book about the manual attachment.

Then I attached the those mdf files by going to the database and r.clicking for attachment.

I solved the issue and thank you for your attention.

 

[MDXer]

Glad to help and happy you have resolved the issue.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck