Invalid object name - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Invalid object name

Author

Topic

asenthilvelan
Starting Member

25 Posts

Posted - 2008-09-11 : 21:31:57

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.

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-09-11 : 21:42:06

Please do not cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110525
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110523
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110526
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110523
and many many more

PLEASE DELETE ALL THOSE CROSS POST and leave only this thread. Posting in multiple forum will not get you the answer fast. Also you should be posting in appropriate forum. As your question is about SSIS, this is the correct forum to post.

KH
[spoiler]Time is always against us[/spoiler]

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-09-11 : 22:42:26

Thanks KH - I would not have been so kind - that was highly annoying.

Be One with the Optimizer
TG

asenthilvelan
Starting Member

25 Posts

Posted - 2008-09-11 : 23:10:09

thanks

I will remove soon

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-09-12 : 08:20:51

Are you using OpenRowset or SQL Command? If SQL Command and passing variables then check syntax such as tick mark or quotes.

asenthilvelan
Starting Member

25 Posts

Posted - 2008-09-12 : 10:38:52

Thanks rgombina for ur attention

I went to the source editor and In found the data access is SQL command - for employee data flow

SELECT Shift.Name AS Shift, Department.Name AS Department, Employee.Title, Employee.LastName, Employee.FirstName
FROM Shift INNER JOIN
Employee ON Shift.ShiftID = Employee.ShiftID INNER JOIN
Department ON Employee.DepartmentID = Department.DepartmentID

For scrapped products data flow, I found data access mode is named query with the follwing command

SELECT ProductCategory.Name AS ProductCategory, ProductSubCategory.Name AS ProductSubCategory, Product.Name AS Product, Product.ProductNumber,
ScrapReason.Name AS ScrapReason, WorkOrder.ScrappedQty
FROM Product INNER JOIN
ProductSubCategory ON Product.ProductSubCategoryID = ProductSubCategory.ProductSubCategoryID INNER JOIN
ProductCategory ON ProductSubCategory.ProductCategoryID = ProductCategory.ProductCategoryID INNER JOIN
WorkOrder ON Product.ProductID = WorkOrder.ProductID INNER JOIN
ScrapReason ON WorkOrder.ScrapReasonID = ScrapReason.ScrapReasonID

Please continue guiding me

Thanks

asenthilvelan
Starting Member

25 Posts

Posted - 2008-09-13 : 17:38:42

Hi

I solved the issue

I attached few mdf files (contains the tables needed for my practice) from the folder in my documents (where I stored all databses from the CD) and which instructed me to attach manually.

This manul attachment I did not do earlier and hence I faced all the problems.

Now everything is OK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources