Data Source Error Message: Local Data - Out of Context

wesselk · Post by **wesselk** » Fri Apr 06, 2007 12:32 pm

We are trying to load data from AS/400 DB2 DB to SQL Server. The DB2 ODBC DSN has been setup on the server. However, when trying to 'view data' the source the job freezes. We tried running with the debugger and I received the following message in Debug Window:

Job Status: Running
Local Data: (Out of Context)

We've been successful loading DB2 data from another box but no luck with this server. Any assistance would be greatly appreaciated!

Thanks,
Kevin Wessel
Weyerhaeuser Company

ray.wurlod · Post by **ray.wurlod** » Sat Apr 07, 2007 3:53 am

Welcome aboard (willkommen?) :D

"Out of context" is only meaningful in the debugger. What it means is that you have items on the watch list that are not visible from the point where the debugger is currently paused. Consider the following design.

Code: Select all

Source ---> Tfmr1 ---> Tfmr2 ---> Tfrm3 ---> Target
       LnkA       LnkB       LnkC       LnkD

Say you have placed LnkA.col3 on the watchlist, but have been stepping through the job a link at a time and are currently paused at Tfmr2. LnkA does not connect to Tfmr2, so that LnkA.col3 would be reported as "out of context".