The data needs to be refresed daily basis. here is the solution which i had attacged ..built but not working...

The insert data is the access database..

the problem is the access database is already built. And data needs to refreshed daily from sql database. So do you know anyway doing it..

Hello All,

I had found the cause of it..

Reason: In Foreach Loop Container, the retreive file name, name and extension was selected but should have been fully qualified

Solved: Selected "fully qualified"...

The path is correct as it goes through Foreachloop container and through sequence container, also it goes check the the audit table and delete the rows but fail to...

thanks guys... i had found the source data has some quality issuess. But for loading data i was using oledb

Shaun

the format is "Delimted" and i process around 50 files but only last file giving error..

I GOT THE SOLUTION

ISNULL(ID) ?0: ID

its working now... thanks mark..

how to create string in this format in the derived column

it is timestamp(6)

i changed the formula

DT_STR,75,1252)((SUBSTRING(Date,1,2) + "-" + SUBSTRING(Date,4,2) + "-" + SUBSTRING(Date,7,4) + " " + SUBSTRING(Date,12,8)))

but now i get invalid month error

[Oracle Destination [3138]] Error: OCI...

BUT HOW TO create the excel file. as i m using the excel destination but not sure how to insert the data.

reply thank u guys.. its been lot of help...

Shaun

i tried it worked now.. but i want to move the file to network in particular location ..

shaun

i tried but it does not allow to store as actual datatype but taking as unicode string..

but how to display in the message source which i am sending e:mail..