You can use derived column task to derive the output in required format.

Regards

MSKR

Hi Jack

Exactly,i need that only i need to select Product from the dropdown then i ill have one more drpodown for product type like wise...

Pls let me know the approch..

Thanks...

Hi

While configuring the properties for the excel to use that variable select the Excelfile property instead of connection string and assaign the variable "@User::varloop" it ill solve the problem.

Regards

Suman

Hi Thanks For the reply

ya i have 3 sql statements , it may return the value or may not return the value .If the 1st statement returns value then...

Hi Ray

Even i had similar requirement.It is possible u can use the variable which you have used in the for loop .That variable contains full file path with the file...

I think you are using the derived column to derive some columns.You also use data conversion transformation and convert the data type to required format and try it.

cheers

MSK Reddy

Hi

According to me you also need to edit the configuration file in your new package, so that it will refer to updated config file.which you have modified.

Regards

Suman

Thanks for the quick response and one more problem is how can we update the rows which are already been inserted.

As i worked in informatica before there we have UpdateStrategy...

Ok Let me elobrate the things...

Here is my flat file which i ill get daily...suppose i have got the flat file today with 10 records and i have loaded the...