May 6, 2002 at 7:00 am
I'm new to DTS Programming and would appreciate some direction on how best to approach this problem.
I have a table storing client names & emails and need to export a report to Excel for email attachment to each of the emails in the table.
I produce the report via a stored procedure that takes clientID as input. I can easily modify that sproc to output clientname/Email as well but I'm unclear as to how best approach using that information in a DTS Package.
Reviewing the documentation i see a few possible approaches & I'm inclined to explore the paramitized query but I'm not sure what problems I'll setup for myself and if there's better alternatives.
thankx
--steve...
May 6, 2002 at 10:36 am
A parametized query will work. You can also use a second package to call your package repeatedly, changing the value of the query for each to match a new recordset.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply