For DT_STR type data types you will get count and count distinct becoz thats the only aggregations possible. Sum, Avg, Min, Max will only be available for number datat types.

You may use the expression somthing like LEN(@[User::FilePath])==0? True : False in the subsequent precedence constraint editor to do your 'else' part OR use this kind of expression to disable...

Usefull links for working with Foreach container with Ado enumerator

http://www.sqlservercentral.com/articles/SSIS/64014/[/url]

and

http://www.codeproject.com/KB/database/foreachadossis.aspx

Escape the characters that are causing problems, e.g.

REPLACE( @[System::ErrorDescription],"'","''")

You can check it in a script task

System.IO.File.Exists(filename)

You can store the value in package variable and take further actions depending on this variable, e.g send mail and disable further steps.

HTH

You can add Derived Column transformation, and in the Derived Column drop down select 'Add as new column'

You can use Execute SQL task to set the recepient emails into a user variable (Note: varchar(max) will not map to string type, you can use varchar(4000) instead)

OR you...

Where exactly are you tying to use the expression? Could you also eloborate on what are you trying to do?

Select from top menu SSIS->Work Offline. This would prevent the package from trying to connect to your datasources

Are you using File.Exists to check the existance? If yes then you have to provide the path, wildcard wouldn't work.

You can use the Foreach File enumerator to provide the File...

Thats sounds right, hope the parameter variable Data Type for the second Execute SQL Task is varchar. The only other thing i can think of is to check the variable...

To view runtime varible values - You can set Breakpoints to your tasks by right click task - > Edit Breakpoint ->choose appropriate event. In your case 'OnVariableValuechaged' event would...

Try changing the variable from Varchar(max) to varchar(4000) in your sql query. I tested it and it worked for me when i made the change.

SSIS is not able to map...

If you are trying to do this in T-Sql then create a function that will return the desired string. Here is the code.

CREATE Function DaysBetweenDates

(

@FromDate smalldatetime,

@ToDate smalldatetime

)

RETURNS varchar(4000)

AS

BEGIN

DECLARE

@DaysInBetween varchar(4000)

SET @DaysInBetween...

If you are sure that the ID column is always going to be 4 characters and the Count will be less than ID then you can fiddle around and do...