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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2010-05-25 : 13:53:39
|
| I have an SSIS package which reads data from a linked SQL Server. It works fine when I run the package itself, but gives me two different errors when I run it using a scheduled job. First error I get is "Opening a rowset for "[dbo].[VW_DATA_NG]" failed. Check that the object exists in the database. End Error" Second Error I get someties is unable to login to the linked server. This job was workin fine for a year before it just broke. It reads data from a linked server view and writes to a flat file. Any suggestions? |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2010-05-25 : 16:20:53
|
| I recreated the Linked servers and that resolved the issue. |
 |
|
|
|
|
|
Error with Package Execution