no the columns names of a particular sheet will not change. we have fixed column names for all the three sheets.

Like say sheet1 always carry 5 columns and sheet2...

the column names are different for all the three sheets....user will be uploading these files from frontend(aspx page). I have integrated the package with asp.net

you mean to say that it is possible to do in a single package with just vb code in it ???

Can u give me a clue on how to dynamically...

Dear Darth,

Need your help again !!!!!!

Let me first explain you the scenario.......

I need to loop through a folder and import the excel files with the filename CustomerMasterDump.xls into the sql...

Hey Vani......

Finally you have done it !!! great !!!

But the mistake you made is setting the filepath variable...

you cannot give the filename or extn in the variable since we will...

Got it.....

Remember SSIS variables are case-sensitive.....very very case-sensitive...

Inthe variables you defined the variable as ObjRecords and in the expression you are using it as objRecordrs.

Sure this should throw an error...

Change...

Hi Vani,

In the file_path variable u r assigining the file a name. and u r not using any other expression to differentiate the files that r created. so evertime the...

I believe you are commiting some mistake in the expression. place the expression i gave in the connectionstring property of the flat file connection manager.

Can u give a brief description...

Hi Vani,

I think there is some problem with your expression , probably some type casting error.

Try the expression given below. This is working fine for me...

@[User::FilePath] + "test" +"_"+...

thanks darth..

it did took a lot of time for me to implement this but finally worked for me....

Hi Vani,

Firstly , take a dataflow task. Add a oledb source with sql command as data access mode. in the query , give a select command to get a list...

Steve ...

U mean the package script task ??? how do I do it?

This package will run as a job scheduled to run every day....

hi Darth....Iam not able to add Microsoft.Office.Interop.Excel in my script.

Here is what i have followed.

1. I closed the package and opened the code view by rt clicking on the package...

Thanks Darth....I would definetely try it out and let you know.

I have followed an example in the below link for looping through the excel sheets.

http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx

Could you please check it out...

Hey Anitha,

you can achieve this by giving the exec sp query in the oledb source.

Now the question is, are you passing any parameters ?

If yes, the parameters should be defined...