I spoke too soon 🙂

Phil's approach is working. But when I try to run the package thru a batch job passing variables for the template path (source) and report path...

Thanks kl25 and Phil for the help. I was able to implement the package using Phil's approach.

palpitations 🙂

Please confirm the control flow should have this process:

1) fst to overwrite the original template w/ the existing template

2) data flow task - oledb source to excel destination

3)...

Phil:

Just to make sure I've understood your approach:

1) In the data flow, I would load the data from the oledb source to the template.

2) Then I would...

I didn't have evaluate as expression set to true for ExceptionReportName. After making that change and running the package, a package validation error comes up. "Error at Exceptions...

I put a Script Component between the oledb source and excel destination to popup the value of ExceptionReportName. The value was C:\Reports\ExceptionReport.xls. I was expecting an excel file...

kl25:

Thanks for your reply.

The value of the variable ExceptionReportPath is C:\Reports\ and the expression is set to C:\Temp\. So during runtime I'd like the excel file to...

No, I don't. Does that property mean that it will not validate the expression during compile time, but until run time?

Should I set the connection variable to the dtsx...

It does. Thank you.

Thanks.

Do I need to provide more information? haven't received a reply. Thanks.

I had to convert this to ssis:

WHEN CAST(T1.[ORIG_DT] as datetime) >= T.[SETTLE_dt] THEN '1'

WHEN CAST(T1.[ISSUE_DT] as datetime)>= T.[settle_dt] THEN '3'

WHEN CAST(T1.[ISSUE_DT] as datetime) >= T.[Output_dt] AND T1.[ISS_STK]...

Thanks Paul

Thanks John. In the process of trying it out. I haven't done step #5 before. Can I follow the steps from this article: http://www.ssistalk.com/2007/04/04/ssis-using-a-script-component-as-a-source/?

This post has been active for more then 3 years 🙂

How would I go about adding a record count in the footer? The record count would capture the...