You will need to have a distinct set of ActivityTagID in your PivotColumnHeaders. Try adding the group by ActivityTagID in your query as such:

DECLARE @PivotColumnHeaders VARCHAR(MAX)

SELECT @PivotColumnHeaders =

COALESCE(

@PivotColumnHeaders...

Hi Debanjan,

You can do this a couple different ways. You can use and XML PATH query with a DB Source, or you can get creative with a script component....

Any time, I have been there myself. 😀

Hi Mark,

Is your User::ERR_ErrorCount variable passed into your script as a ReadOnlyVariable or ReadWriteVariable.

Thanks,

Dave

Hi Mark,

You could use a package variables to keep a running count of failed files, and maybe another to keep summary details of the errors that are handled.

or

You...