<p>Right now I have an <a href="http://en.wikipedia.org/wiki/SQL_Server_Integration_Services" rel="nofollow noreferrer">SSIS</a> package that runs every morning and gives me a report on the number of packages that failed or succeeded from the day before. The information for these packages is contained partly within the <code>sysjobs</code> table (a system table) within the <code>msdb</code> database (a system database) in <a href="http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2005" rel="nofollow noreferrer">SQL Server 2005</a>.</p>

<p>When trying to move the package to a C# executable (mostly to gain better formatting over the email that gets sent out), I wasn't able to find a way to create a dbml file that allowed me to access these tables through <a href="http://en.wikipedia.org/wiki/Language_Integrated_Query" rel="nofollow noreferrer">LINQ</a>. I tried to look for any properties that would make these tables visible, but I haven't had much luck.</p>

<p>Is this possible with <a href="http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL_.28formerly_called_DLINQ.29" rel="nofollow noreferrer">LINQ&nbsp;to&nbsp;SQL</a>?</p>

[{'answer_id': 54232, 'author': 'Danimal', 'author_id': 2757, 'author_profile': 'https://Stackoverflow.com/users/2757', 'pm_score': 0, 'selected': False, 'text': '<p>It may not be available in the designer, but why not just add it to the DBML file itself?</p>\n'}, {'answer_id': 54360, 'author': 'Ryan Lundy', 'author_id': 5486, 'author_profile': 'https://Stackoverflow.com/users/5486', 'pm_score': 6, 'selected': True, 'text': "<p>If you're in Server Explorer, you can make them visible this way:</p>\n\n<ul>\n<li>Create a connection to the server you want.</li>\n<li>Right-click the server and choose Change View > Object Type.</li>\n<li>You should now see System Tables and User Tables.  You should see sysjobs there, and you can easily drag it onto a .dbml surface.</li>\n</ul>\n"}]
['https://Stackoverflow.com/questions/54222', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1108/']