{"id":24,"date":"2008-02-22T15:02:16","date_gmt":"2008-02-22T14:02:16","guid":{"rendered":"http:\/\/mayeur.com\/wordpressfr\/?p=24"},"modified":"2008-03-19T21:23:46","modified_gmt":"2008-03-19T20:23:46","slug":"script-ssis-sur-une-connexion-smo","status":"publish","type":"post","link":"https:\/\/mayeur.com\/wordpressfr\/script-ssis-sur-une-connexion-smo\/","title":{"rendered":"Script SSIS sur une connexion SMO"},"content":{"rendered":"<p>Ayant eu r\u00e9cemment besoin d&rsquo;\u00e9crire un package SSIS, pour une proc\u00e9dure d&rsquo;exploitation SQL Server, j&rsquo;ai eu besoin de r\u00e9utiliser des connexions de type SMO dans des scripts du package. Les connexions SMO sont utilis\u00e9es notamment par les t\u00e2ches de transfert d&rsquo;objets entre bases de donn\u00e9es (transfert de tables, de proc\u00e9dures stoqu\u00e9es, &#8230;). J&rsquo;utilisais une de ces t\u00e2ches, et j&rsquo;avais \u00e9galement besoin de faire quelques traitements sp\u00e9cifiques en script .NET sur ces m\u00eame connexions. Ce type d&rsquo;utilisation \u00e9tant mal document\u00e9, voici comment j&rsquo;ai proc\u00e9d\u00e9 :<\/p>\n<p><code>Imports System<br \/>\nImports System.Data<br \/>\nImports System.Math<br \/>\nImports Microsoft.SqlServer.Dts.Runtime<br \/>\nImports Microsoft.SqlServer.Management.Smo<br \/>\nPublic Class ScriptMain<\/p>\n<p>Public Sub Main()<br \/>\nDim server As Server<br \/>\nDim db As Database<\/p>\n<p>server = CType(Dts.Connections(\"destination\").AcquireConnection(vbNull), Server)<br \/>\ndb = server.Databases(\"MYDB\")<br \/>\ndb.ExecuteNonQuery(CStr(Dts.Variables(\"myQuery\").Value))<\/p>\n<p>Dts.TaskResult = Dts.Results.Success<br \/>\nEnd Sub<\/p>\n<p>End Class<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ayant eu r\u00e9cemment besoin d&rsquo;\u00e9crire un package SSIS, pour une proc\u00e9dure d&rsquo;exploitation SQL Server, j&rsquo;ai eu besoin de r\u00e9utiliser des connexions de type SMO dans des scripts du package. Les connexions SMO sont utilis\u00e9es notamment par les t\u00e2ches de transfert d&rsquo;objets entre bases de donn\u00e9es (transfert de tables, de proc\u00e9dures stoqu\u00e9es, &#8230;). J&rsquo;utilisais une de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[8,9],"tags":[],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-etl","category-sql-server"],"_links":{"self":[{"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":0,"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/posts\/24\/revisions"}],"wp:attachment":[{"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/media?parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/categories?post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mayeur.com\/wordpressfr\/wp-json\/wp\/v2\/tags?post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}