its working.

I created new column in derived column and used the above expression with datatye as string.It worked.

(DT_STR, 6,1252)((DT_STR,4,1252)YEAR(DATE_COLUMN) +

(DT_STR,4,1252)MONTH(DATE_COLUMN))

I used this expression in derived column task ...... date_column in datebase timestamp (source) and destination column is int.

I am getting error in oledb destination....cannnot convert DT_DBtimestamp...

can we do all that in data convertion task

Thank you.

But how can I format in Data Conversion to YYYYMM.

declare @var varchar (20)

set @var = (SELECT distinct column from table where id = 1234 )

select @var

IF (@var is null) or (@var = '')

PRINT 'space'

else

print 'no space'

I need to send my package to production so i need to create a config file..........when i tried doing that its showinng no attributes for selected items some thing......i...

i dont understand ur questions.......

I have a doubt...why do we use .config file some packages use them n some do not....................

sorry I dont have the dump I had before but i did not find that yesterdat any way i asked my friend she may be having it..........

thanks...its working fine now i could update 30000 records in less than a sec .I dont know y i faced that prob morning any idea?

update table

SET Indicator='Y' where id= 1324

I have a update command just update indicator field to Y,

even i have no fields to update its taking long time around 20 min...the fields need to be updated are...

i did not use FTP task i used batch file................i work from office and if i have anything left out I will work from home tooo

I crested a staging table inside the loop and after the loop i used one more data flow task and loaded from tabel to flat file...

thanks a lot for ur...

I placed a row count before loop.

Inside the loop each time loop executes records are added to the flat file when i can not use overite option ,when...

thanks FTP is working.......................i used batch file to transfer..............the script is same as in above post