I need to build a SSIS package that will run different queries based on user input from a stored proc.. The proc is called prPriceList and uses the variable @PriceListName.. If someone calls the proc and puts through the name WholeSale then an SSIS package wil run and grab the results of that stored proc if someone puts through Retail than the SSIS package will run grab those results and output an Excel file.. What is the best way to do this? We use VB 2008 here as well as SQL Server 2008 and Visual Studio 2008
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.