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-10 : 11:49:22
|
| Invalid object name ‘shift’‘Statement could not be prepared’I have been working with the book Microsoft SQL integration services step by step. I loaded the sample data from the CD. I opened the sample project SSIS – then sample packages – CreateList.dtsx in the BIDS. In the control flow tab, I found Data flow task ‘employee list’ and data flow task ‘scrppedproducts’ with yellow triangles says “validation warnings occurred”. When I go to data flow tab, I found a red cross in the (OLE DB source – employee query). I tried to fix this- went to OLE DB source editor and then to connection manager and fixed the server and db name, test connection was successful. Yet these Red Cross and yellow triangles did not go. After connection manager, I clicked the columns in the source editor. 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’.Can some one help me to fix these. Thanks for your attention |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 11:55:41
|
Ww don't have access to yor package nor data nor databases.Figure out where the object shift is referenced and then make the proper change.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-13 : 13:27:33
|
| It seems like you're referencing an object called shift which does not exist. Are you sure you've such a table/view existing? also are you pointing to correct server and db? |
|
|
|
avsone
Starting Member
1 Post |
Posted - 2010-06-21 : 04:45:04
|
quote:
Originally posted by asenthilvelan
Invalid object name ‘shift’‘Statement could not be prepared’I have been working with the book Microsoft SQL integration services step by step. I loaded the sample data from the CD. I opened the sample project SSIS – then sample packages – CreateList.dtsx in the BIDS. In the control flow tab, I found Data flow task ‘employee list’ and data flow task ‘scrppedproducts’ with yellow triangles says “validation warnings occurred”. When I go to data flow tab, I found a red cross in the (OLE DB source – employee query). I tried to fix this- went to OLE DB source editor and then to connection manager and fixed the server and db name, test connection was successful.Can some one help me to fix these. Thanks for your attention
I added answer for ending topic- After fixing connection you just need to reopen this package or right click "Reload and Upgrade" in this package in solution tree |
|
|
|
|
|
|
Invalid object name