Thanks for the suggestion elliott

I'll try adding breakpoint at string filepath = Dts.Variables["user::var_file_path"].Value.ToString();

I am extracting the data(same or different) and loading it to SQL server table for the sake...

I used this script for declaring the variables:

public void Main()

{

// TODO: Add your code here

string filepath = Dts.Variables["user::var_file_path"].Value.ToString();

...

Thanks Elliott Whitlow.

Well I am trying to load a folder which contains same structured file (same column count, order and information) in three different format (.xls, .xlsx & .txt). And...