December 28, 2009 at 5:59 am
hi
i have a simple SSIS package which transfer data fro sql to mdb file
today i added a new table on slq side and want to incorporate that in this package
but when i am trying to map it in OLE DB source component it showing invalid object name "table name " but i can see it through mgmt studio
i have checked my connection many times all are good as wroking fine with other tables
Error1Validation error. QUESTION- ANSWER: DMP_SURVEY_ANSWER_FILE [8774]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E37 Description: "Invalid object name 'DMP_SURVEY_ANSWER_FILE'.".SSIS_DataDump_Survey.dtsx00
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 28, 2009 at 9:06 am
Verify the schema the table belongs to is correct. If you created the table, it may have been created with your username as the schema.
December 28, 2009 at 9:30 pm
it got corrected automatically , i closed the project and restarted it again, and didnt find the problem dont know it got resolved ..its working fine now
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply