{"id":126,"date":"2008-07-07T17:04:36","date_gmt":"2008-07-07T17:04:36","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?page_id=126"},"modified":"2008-07-07T17:04:36","modified_gmt":"2008-07-07T17:04:36","slug":"vbscript-function-deltaimportspending","status":"publish","type":"page","link":"https:\/\/www.wapshere.com\/missmiis\/vbscript-function-deltaimportspending","title":{"rendered":"vbscript: Function DeltaImportsPending"},"content":{"rendered":"

To use with Delta imports from SQL – check if there are any lines in the Delta table before running an Import. By only running delta imports when there’s actually something to do you can save on time and transaction log space.<\/p>\n

\n

Const DB_CONNECT_STRING = \u00e2\u20ac\u0153Provider=SQLOLEDB;Data Source=(local);Initial Catalog=DB-name<\/em>;Integrated Security=SSPI\u00e2\u20ac\u009d<\/span><\/p>\n

‘—————————————————–
\n‘\u00c2\u00a0 Function DeltaImportsPending
\n‘\u00c2\u00a0 + Returns TRUE if the Delta table has content
\n‘—————————————————–<\/p>\n

Function DeltaImportsPending(Delta_Table)
\n\u00c2\u00a0 Dim objDB, sqlQuery, recordset<\/p>\n

\u00c2\u00a0 Set objDB = CreateObject(“ADODB.Connection”)
\n\u00c2\u00a0 Set recordset = CreateObject(“ADODB.Recordset”)<\/p>\n

\u00c2\u00a0 objDB.Open DB_CONNECT_STRING
\n\u00c2\u00a0 sqlQuery = “SELECT COUNT (*) AS num FROM ” & Delta_Table<\/p>\n

\u00c2\u00a0 recordset.Open sqlQuery, objDB<\/p>\n

\u00c2\u00a0 If recordset.Fields(“num”) > 0 Then
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 DeltaImportsPending = TRUE
\n\u00c2\u00a0 Else
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 DeltaImportsPending = FALSE
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 WriteLog(“No pending delta imports – stopping.”)
\n\u00c2\u00a0 End If<\/p>\n

\u00c2\u00a0 objDB.Close<\/p>\n

End Function<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

To use with Delta imports from SQL – check if there are any lines in the Delta table before running an Import. By only running delta imports when there’s actually something to do you can save on time and transaction log space. Const DB_CONNECT_STRING = \u00e2\u20ac\u0153Provider=SQLOLEDB;Data Source=(local);Initial Catalog=DB-name;Integrated Security=SSPI\u00e2\u20ac\u009d ‘—————————————————– ‘\u00c2\u00a0 Function DeltaImportsPending ‘\u00c2\u00a0 +…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-126","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/Pkp1o-22","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=126"}],"version-history":[{"count":0,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/126\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}