Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Single variable across multiple packages
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

Starting Member

16 Posts

Posted - 09/12/2013 :  12:12:30  Show Profile  Reply with Quote
I have four separate import processes that, perhaps out of ignorance, I created in four separate SSIS packages. Each package calls a stored proc GetNewBatchNum(), which writes a row to tblBatch, retuning the new BatchID.

My problem is, I now want all four packages to use a single BatchID, not four different ones. How do I call my GetNewBatchNum proc once, then use the returned value for each import package? Any information appreciated.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/12/2013 :  16:01:16  Show Profile  Reply with Quote
you could create a master package where you can move the execute proc step. Add a variable inside that to store the returned value. Then use four execute package tasks to call your current four packages. Inside child packages add a variable to get batchid and set the value using parent package variable configuration to received the value from the variable created in master package.

SQL Server MVP
Go to Top of Page

Starting Member

9 Posts

Posted - 02/25/2018 :  04:15:30  Show Profile  Reply with Quote
[b][url=]Men UGG Boots online store[/url][/b][b][url=]classical style Men UGG Boots[/url][/b]<ul><li><strong><a href="">ugg ear covers for discount</a></strong></li><li><strong><a href="">Ugg boots for women</a></strong></li><li><strong><a href="">ugg shoes for kids</a></strong></li></ul><br><title>Ugg Boots Outlet Online,</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><meta name="keywords" content="Professional UGG Boots Stores " /><meta name="description" content="Ugg Boots Outlet Online - Professional UGG Boots Stores" /><meta http-equiv="imagetoolbar" content="no" /><meta name="robots" content="noindex, nofollow" /><base href="" /><link rel="canonical" href="" /><link rel="stylesheet" type="text/css" href="" /><link rel="stylesheet" type="text/css" href="" /><link rel="stylesheet" type="text/css" href="" /><link rel="stylesheet" type="text/css" media="print" href="" /><div style="margin:0 auto; clear:both;"><div id="lang_main_page" style="padding-top:10px; clear:both;text-align:center;margin-right:auto;margin-left:auto;"><b>language:</b><a href=""><img src="" alt="Deutsch" title=" Deutsch " height="15" width="24"></a>  <a href=""><img src="" alt="Français" title=" Français " height="15" width="24"></a>  <a href=""><img src="" alt="italiano" title=" italiano " height="15" width="24"></a>  <a href=""> <img src="" alt="Español" title=" Español " height="15" width="24"></a>  <a href=""><img src="" alt="Português" title=" Português " height="15" width="24"></a>  <a href=""><img src="" alt="???" title=" ??? " height="14" width="24"></a>  <a href=""><img src="" alt="russian" title=" russian " height="15" width="24"></a>  <a href=""><img src="" alt="arabic" title=" arabic " height="15" width="24"></a>  <a href=""><img src="" alt="norwegian" title=" norwegian " height="15" width="24"></a>  <a href=""><img src="" alt="swedish" title=" swedish " height="15" width="24"></a>  <a href=""><img src="" alt="danish" title=" danish " height="15" width="24"></a>  <a href=""><img src="" alt="Nederlands" title=" Nederlands" height="15" width="24"></a>  <a href=""><img src="" alt="finland" title=" finland " height="15" width="24"></a>  <a href=""><img src="" alt="ireland" title=" ireland " height="15" width="24"></a>  <a href=""><img src="" alt="English" title=" English " height="15" width="24"></a>  </div></div><div><div id="head"><div id="head_right"> <div id="head_right_top"></div> <div id="head_right_bottom"> <div id="head_right_bottom_left"> Welcome! <a href="">Sign In</a>or <a href="">Register</a> </div> <div id="head_right_bottom_right"> <div id="cartBoxEmpty"><a href=""><img class="cart-icon empty float-left" src="" /></a>Your cart is empty</div> </div> </div></div><div id="head_left"> <a href=""><img src="" alt="Powered by Zen Cart :: The Art of E-Commerce" title=" Powered by Zen Cart :: The Art of E-Commerce " width="141" height="90" /></a></div> <div id="head_center"> <form name="quick_find_header" action="" method="get"><input type="hidden" name="main_page" value="advanced_search_result" /><input type="hidden" name="search_in_description" value="1" /><div class="search-header-input"><input type="text" name="keyword" size="32" maxlength="130" value="Search..." onfocus="if (this.value == 'Search...') this.value = '';" onblur="if (this.value == '') this.value = 'Search...';" /></div><div class="button-search-header"><input type="image" src="" value="Serch" /></div></form> </div> <div class="clear" style="clear:both"></div> <div id="header_menu"> <ul id="lists"> <div class="menu-middle"> <ul> <li class="is-here"><a href="">Home</a></li> <li class="menu-mitop" style="width:250px"><a href="">Ugg Women Boots</a></li> <li class="menu-mitop" style="width:250px"><a href="">Ugg Men Boots</a></li> <li class="menu-mitop" style="width:250px"><a href="">Ugg Kids Boots</a></li></ul> </div> <div class="hidemenu"> <div id="head_center"> </div></div> </ul> </div></div><div class="clear" style="clear:both"></div><div id="content"><table width="100%" border="0" cellspacing="0" cellpadding="0" id="contentMainWrapper"> <tr> <td id="navColumnOne" class="columnLeft" style="width: 220px"><div id="navColumnOneWrapper" style="width: 220px"><div class="leftBoxContainer" id="currencies" style="width: 220px"><div class="sidebox-header-left "><h3 class="leftBoxHeading " id="currenciesHeading"><label>Valuta</label></h3></div><div id="currenciesContent" class="sideBoxContent centeredContent"><form name="currencies_form" action="" method="get"><select name="currency" onchange="this.form.submit();"> <option value="USD">US Dollar</option> <option value="EUR" selected="selected">Euro</option> <option value="GBP">GB Pound</option> <option value="CAD">Canadian Dollar</option> <option value="AUD">Australian Dollar</option> <option value="JPY">Jappen Yen</option> <option value="NOK">Norske Krone</option> <option value="SEK">Swedish Krone</option> <option value="DKK">Danish Krone</option> <option value="CNY">CNY</option></select><input type="hidden" name="main_page" value="index" /><input type="hidden" name="cPath" value="8" /></form></div></div><div class="leftBoxContainer" id="categories" style="width: 220px"><div class="sidebox-header-left main-sidebox-header-left"><h3 class="leftBoxHeading main-sidebox-header-right" id="categoriesHeading">Categorie</h3></div><div id="categoriesContent" class="sideBoxContent"><div class="categories-top-list no-dots"><a class="category-top" href=""></a></div></div></div></div></td> <td id="columnCenter" valign="top"> <div id="navBreadCrumb">Home</div><div class="centerColumn" id="indexProductList"><h1 id="productListHeading">Home</h1><br class="clearBoth" /><div id="productListing"><div class="productListing-data">There are no products to list in this category.</div><br class="clearBoth" /> </div></div></td> </tr></table></div><div id="navSuppWrapper"><div id="navSupp" style=" margin-bottom:10px; margin-top:8px; width:100%; text-align:center;"><a style="color:#000; font:12px;" href="">Home</a>  <a style="color:#000; font:12px;" href="">Shipping</a>  <a style="color:#000; font:12px;" href="">Wholesale</a>  <a style="color:#000; font:12px;" href="">Order Tracking</a>  <a style="color:#000; font:12px;" href="">Coupons</a>  <a style="color:#000; font:12px;" href="">Payment Methods</a>  <a style="color:#000; font:12px;" href="">Contact Us</a>  </div><div style=" margin-bottom:10px; margin-top:10px; width:100%; text-align:center;"> <a style=" font-weight:bold; color:#000;" href="" target="_blank">NEW UGG BOOTS</a>    <a style=" font-weight:bold; color:#000;" href="" target="_blank">UGG BOOTS MENS</a>    <a style=" font-weight:bold; color:#000;" href="" target="_blank">UGG BOOTS WOMEN</a>    <a style=" font-weight:bold; color:#000;" href="" target="_blank">UGG BOOTS KIDS</a>    <a style=" font-weight:bold; color:#000;" href="" target="_blank">DISCOUNT UGG BOOTS</a>   <a style=" font-weight:bold; color:#000;" href="" target="_blank">CHEAP UGG BOOTS</a>  </div><DIV align="center"> <a href="" ><IMG src=""></a> </DIV><div align="center" style="color:#000;">Copyright © 2012-2013 All Rights Reserved. </div></div></div><div id="comm100-button-148"></div><strong><a href="">Men UGG Boots online store</a></strong><br><strong><a href="">classical style Men UGG Boots</a></strong><br><br><br><a href=""> blog </a><br><br><a href=""> </a><br><br><a href=""> About blog </a>
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000