Some other things to look for:

Did a field get defined as numeric before but now contains non-numeric data or vice versa?

Do you have a column that has mixed types (some...

Try reading in the variable into your script, adding 1 to it, and writing it back out. Then the new value will be preserved.

We receive fixed width files that are divided into sections where the section begins with a header row (starts with HD), has zero or more detail rows (starts with UD),...

Thank you. I am unfamiliar with CLR scripts. Could you point me to some documentation on them?

As for using a script task, the closest I have come is...

You only need the Excel drivers.

One possibility is to put a script component after the sort that saves the key fields for the previous row. When a new row comes in, it compares its...

Yes, that should work. I do not know exactly how it defines week of the year (does it begin on a Sunday or the day Jan 1 lands on,...

Correction!

"\\et\\loc\\files\\W"+ (DT_STR, 200, 1252) DATEPART( "wk", GETDATE() )

Try this

"\et\loc\files\W"+ (DT_STR, 200, 1252) DATEPART( "wk", GETDATE() )

Yes to all questions.

First create the sendmail package.

Right-click in the open space and select package configurations.

Add the variables that are to be passed from the parent package.

Configuration type is parent package variable and...

One possibility is to put the send mail task in a package that other packages can call.

You can access variables in a conditional split transformation.

In your data flow task, add a percentage sampling transformation. It will split the data into 2 paths. Pass the path you want to your next transformation.

If the input files are delimited and have column headers, the scripting might be easier.

I have an application where we receive Excel files from several sources. None...