i can send you the proc ... but is there any other way that we can make it private

thank you.. for your time

before bothering you again, i will check with team that can take care of this ...but what should i tell them. Should i explain them...

Option for code ..

Thank you for replying...

ok when i make sure that in source OLEDB

draged an OLEDB Source task to control flow and got the connection manager. selected...

Table1 (column ADDEDDATE) is in the form

10/1/2005 12:00:00 AM

.

.

8/18/2007 12:00:00 AM

.

.

i guess, we can't do when the column is in the above form

i can't do this, as i am using Orcale OLEDB....

All i am using is Execute task and variable ....My requriment is to get the variable update as soon as the execute task gets green...Plz correct me if this not...

I am sorry ..if i was not clear. I meant to say, have no idea about method....

I am new to ssis, i have no idea about method...all i just care is to get the value assigned to Variable Y through the Query

Thank u all

But i tried doing as you mentioned...but still the warnings exists...it says "TRUCATION may occurs DUE TO INSERTING DATA FROM DATA FLOW COLUMN, "COLUMN B " WITH LENGTH OF 10...

Thanku for the reply ...but whats this o/s ???

Yes ..i am running my package on 64 bit machine. But i am not sure to get the drivers for orcale 64 bit.....i guess there is no kind of 64...

thank you ....

i need a expressions with my package name (using system variable) and today's date..

ex ABC110307 this should be my outcome

where ABC - package name

110307 is today's date

C#....thank you