<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Custom Task : SASStoredProcessService 9.2 in SAS Enterprise Guide</title>
    <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Custom-Task-SASStoredProcessService-9-2/m-p/44963#M5177</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Hi there,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;I am trying to use the new SASStoredProcessService (StoredProcessService.dll and not the old way sps.dll).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;The following experience is ok but i would not to send the userContext&amp;nbsp; (because i am in a SEG Custom Task already connected)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Dim usrContext As New&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;SAS.BI.AuthenticationService.ClientUserContext.UserContext&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Dim login As New SAS.BI.AuthenticationService.ClientUserContext.Login&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ' Initiate connection&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; login = usrContext.GetOmrCredentials()&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ' Define stored process&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Dim stp As New&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;SAS.BI.StoredProcessService.StoredProcess(&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN lang="EN-US" style="background-color: yellow; font-size: 10.5pt; color: red; font-family: Courier;"&gt;usrContext&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;, "/Shared&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;Data/Reports/Examples/Test_VBNET")&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;any ideas ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Greg&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 03 Feb 2012 13:26:50 GMT</pubDate>
    <dc:creator>Greg</dc:creator>
    <dc:date>2012-02-03T13:26:50Z</dc:date>
    <item>
      <title>Custom Task : SASStoredProcessService 9.2</title>
      <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Custom-Task-SASStoredProcessService-9-2/m-p/44963#M5177</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Hi there,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;I am trying to use the new SASStoredProcessService (StoredProcessService.dll and not the old way sps.dll).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;The following experience is ok but i would not to send the userContext&amp;nbsp; (because i am in a SEG Custom Task already connected)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Dim usrContext As New&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;SAS.BI.AuthenticationService.ClientUserContext.UserContext&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Dim login As New SAS.BI.AuthenticationService.ClientUserContext.Login&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ' Initiate connection&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; login = usrContext.GetOmrCredentials()&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ' Define stored process&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Dim stp As New&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;SAS.BI.StoredProcessService.StoredProcess(&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN lang="EN-US" style="background-color: yellow; font-size: 10.5pt; color: red; font-family: Courier;"&gt;usrContext&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;, "/Shared&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="background-color: white; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN lang="EN-US" style="font-size: 10.5pt; color: black; font-family: Courier;"&gt;Data/Reports/Examples/Test_VBNET")&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;any ideas ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #eef4f9; font-size: 12px; font-family: Arial, Helvetica, sans-serif;"&gt;Greg&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 03 Feb 2012 13:26:50 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Enterprise-Guide/Custom-Task-SASStoredProcessService-9-2/m-p/44963#M5177</guid>
      <dc:creator>Greg</dc:creator>
      <dc:date>2012-02-03T13:26:50Z</dc:date>
    </item>
    <item>
      <title>Custom Task : SASStoredProcessService 9.2</title>
      <link>https://communities.sas.com/t5/SAS-Enterprise-Guide/Custom-Task-SASStoredProcessService-9-2/m-p/44964#M5178</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Greg,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I believe you still need to pass a user context object, but you're correct: you should not have to reauthenticate.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'll see if I can find an example for getting the user context with an existing session.&amp;nbsp; In the meantime, you might see if you can make use of the information in SAS.Tasks.Toolkit.Helpers.SasMetadataProfile class.&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I think that if you make use of that class, you'll have add additional references to your project for:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; SAS.EG.SDS.Model.dll&lt;/P&gt;&lt;P&gt;&amp;nbsp; SAS.EG.SDS.Metadata.MetadataManager.dll&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;That's just a requirement to resolve some external dependencies when building the project.&amp;nbsp; The classes within those DLLs are not documented for customer use: only the classes in SAS.Tasks.Toolkit.dll.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Chris&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 03 Feb 2012 17:57:52 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Enterprise-Guide/Custom-Task-SASStoredProcessService-9-2/m-p/44964#M5178</guid>
      <dc:creator>ChrisHemedinger</dc:creator>
      <dc:date>2012-02-03T17:57:52Z</dc:date>
    </item>
  </channel>
</rss>

