Create a event handler at package level to capture the OnError Event.

Even Hanlders - > OnError

Add a SendMail task here. There are system variables: @[System::ErrorCode], @[System::ErrorDescription] that you can use...

As a first step in your package you can use Execute SQL task to check the history table

SELECT CASE WHEN EndDate IS NULL THEN convert(bit,0) ELSE convert(bit,1) END as LastRunStatus...

Trim would just trim the spaces. You can use a derived colum with Substring funciton on your address field OR you can use Substring function in you source query

Derived Column

SUBSTRING(...

What package properties are you configuring using ini file? I have never used ini files for package configs. SSIS provides config using Environment variable, sql server table, xml.

I would suggest...

In your excel file connection - > Expressions - >ExcelFilePath->@[User::gv_FileName]

If you are using fully qualified name in Foreach loop then you don't have to do anything in the connection string. Just put the variable that you used in the...

I guess your foreach loop in ssis didn't work becoz you were not dynamically changing your excel connection - so even though you were picking excel files in the for...

Is the structure of all the Excel file same - Are they going to insert in one single table?

Also are you building the connection dynamically using the loop?

Forgot to mention that you would need to import System.IO to use File class.

Imports System.IO

~Mukti

Menu->SSIS->Logging

Please follow Adding and Configuring Logging

HTH

~Mukti

If you are already creating a log file for your pacakge you can attach this file in you Send Mail task but if you just want to alert the user...

There could be many ways you could do this. Here is one.

Step1: First create a variable called DisableStep of datatype boolean

Step 2: put all your package main tasks into a...

I think i didin;t think through properly. The way to do this will be to have a variable that will generate the file name

"C:\\"+

(DT_WSTR, 4) DATEPART( "yy", getdate()) +...

In your file connection you can use expression to generate the folder name.

Expression- > connection String - > Use following expression

"D:\\Downloaded Files\\" +

(DT_WSTR, 4) DATEPART( "yy", getdate())...

You can do this iby setting Expression for Flat File connection. Select the flat file ->Select Expression (from properlty window) - >Property expression editor - >connection string> and then fill...