1) Just right click the Project in the solution explorer

2) Go to properties

3) Select Debugging in the left panel.

4) In Debug option section : Make Run64Bit Runtime --> False

Its File System Task

Hi Phil,

I do not have to use any scripts. no coding stuff. So I think i need to create some expression like that that will generate Folder_v1 etc. Can you...

"However if would be far easier to use John's suggestion as setup excel as a destination to delete data."

Can you let me know how can we achieve this ???

Not necessary i need File System task.Can i use any other control to Delete Data ???

I am not getting anything as "Parent package variable " i am just getting Package Configuration

Hey John can you please elabroate , i am unable to get the it. And dint get which configuration drop down 🙁

Hey can any one plz give me a expression to Replace / Rename file name.

I want my file name to be eg: Material_TodaysDate ie Materials_20110418.XLS

please help me with this expresion....

Please help.

I have to check this condition : (select count(distinct columnName) From tablename) > 1

Which transformation should i use for it .

Can you let me know how to use Aggregate transformation to remove duplicate. I tried using Aggregate but it just gave me count of all the columns .