Hi notes4we,

Try using this expresion in your derived column calculation

ISNULL(col1) && ISNULL(col2) ? NULL(DT_WSTR,10) : ISNULL(col1) && (!ISNULL(col2)) ? (DT_WSTR,20)col2 : ISNULL(col2) && (!ISNULL(col1)) ? (DT_WSTR,20)col1 : (DT_WSTR,20)col1 + ","...

Use expression to generate the filepath. Go to Expressions->FileAttachements in the SendMail Task Editor and use the following expression. Change the servername and foldername accordingly

"\\\\ServerName\\FolderName\\FileName_" + (DT_WSTR, 4) DATEPART("yyyy",getdate()) +...

You will have to Export the package to file system to edit it. you can then redeploy to filesystem if you want.

If you are storing the results of this query in a Int32 varible Var1 for e.g. then in the Presedence Constriant Editor you can choose Expression and use something like

@[User::Var1]==0?False:True

HTH

~Mukti

It's in a text file.

This is a feed for an application that needs the data in that format. I think I am going to go for the script option.

Thanks.

Alright to make it clearer. When one side sees the Lock.lck they cannot start their operation. that means when mainfram team starts copying they need to first check for lock.lck...

The solution sounds simple and good to me. If i were you i would just ask them to place the empty file and name it Lock.lck (lock file) before they...

Excel connection has the ExcelFilePath that you can set dynamically. (Edited by previous answer too).

Use the File Enumerator in ForEach loop.

For making your excel connection dynamic you can use expressions. For this first create a package variable that will hold the filepath.

Now Create a Excel Connection, in the properties ->...

Use expression to set the connection string for your excel connection. Use a variable to set the conection string. You can do this by Properties->Expressions->ExcelFilePath-> Set your vairble here.

Now use...

I assume the header info is same for all. If thats the case then you can use conditional split to split the header rows from data rows.

HTH

~Mukti

Step 1 - Create a flat file conneciton on the network. Use expressions to set the connection string. Use expression to generate file name as required:

"FileName" + (DT_WSTR, 10)...

Yes create the Execute SQL task before your Data flow that will truncate the table.

I would just create the table for developemnt and create all the mappings. Your 1st step should then drop and recreate the table while executing.

HTH

Mukti