Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gaitchis
Starting Member
5 Posts |
 Posted - 2007-04-25 : 17:53:25
|
| Hi,I have a DTS package (txGLBalances_WA1_PL_Annual_2006_Item_BUKRS_LSMWSel.exp) which currently takes 2 parameters (as input boxes).What I am looking at doing is based on the results of a query - SELECT DISTINCT BUKRS, MONATFROM dswFI.dbo.txGLBalances_WA1_BS_2007_Header_LSMWSelloop through this query and then run the DTS package passing the results as parameters into the package.I believe that this is able to be achieved through the use of a StoredProc. Can anyone assist with this dilemna. |
|
|
|
|
|
Looping results in a stored proc to run a DTS