Good lead Barry. I turned on logging and noticed that practically nothing happened, including PostExecute, until I took the data viewer out and let the package run to completion. Thanks...

Problem solved. The script was pushing data into a derived column transformation with a data viewer in between. When I elimnated the data viewer the script ran correctly. It seems...

I'll have to check logging tomorrow afternoon. I will be tied up until then. Thanks.

Thanks, that makes sense and works fine.

I sort of need the % sign in the variable because users will be maintaining the table. They will be able to add other masks with wildcards. I may be...

I set the permissions as recommended by the post but I am still unable to connect to WMI. I saw a number of posts recommending re-registering certain DLLs:

Regsvr32 Msxml3.dll

Regsvr32...

I know what you neam by confusion. I think SSIS has the same issue sometimes. I'll try to recreate the report today and let you know what I see.

I checked the Tablix properties again and both "Repeat Header Rows (and Columns) on each page are checked"

In advanced mode I can check "Repeat On New Page True" on the...

I was sure this would be the answer, but it didn't help. Thanks anyway

Perhaps I'm not describing my problem correctly. I've attached a screen shot of the report design. I need the titles in the sesction with the green background to repeat on...

That was checked by default but the headers still don't display. Thanks.

I tried the solutions in the link but they didn't solve my problem. The link tells you how to keep the headers visible when scrolling through a long web page...

It's more complicated than that. In the data flow, regardless of the constraint (lookup match, lookup no match, lookup error) the post executes for all three scripts connected to the...

Ignore that last response, I found it. Problem solved. Thanks for the help. Your timing was perfect, I was the victim of a self-inflicted MSSQL wound yesterday. I really needed...

I was not able to find this file either.