Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asenthilvelan
Starting Member
25 Posts |
 Posted - 2008-09-11 : 21:37:19
|
| 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 problemQ.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.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Invalid object name