Hi peter,

Source file is flatfile.

and i implement following expression in derived column.

([datestring ] == "0") ? (DT_DBTIMESTAMP)0 : (DT_DBTIMESTAMP)(SUBSTRING([datestring ],1,4) + "-" + SUBSTRING([datestring ],5,2) + "-"...

Hi peter thanks for u suggestion.

i did what u suggested and i implement expression in derived column transformation.

the expression is:

(ISNULL([date string])) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING([date string], 7, 4) + "-"...

Thanks very much Chris Morris and steveb

murali

Thank u Steveb

if u dont mind can u write the related script otherwise tell me the related link.because i dont know coding part.

Thanks

Murali

Hi Phil

its not coincidence.both are working same company.we sent without know each other.beacuse we are traying this for past 3 days.if i distrub sorry.if u know the answer tell me...

Hi

Excel Source and Excel destinations dont work for Excel 2007.i have little bit know it is available only OLE DB source and OLE DB destination

but how it is connect

Thanks

murali

Is it possible add a message in dataflow level pls tell me anybody

Hi Jeff thank u for answering

i have one doubt where i have to write above Querie in SSIS.

thanks

murali

Hi all,

i have done above requirement but it show in my destfolder like this

file1-92008.txt,file2-92008.txt...etc

for above rename i implement expression in fulldestfilepathname

@[User::destPath] + SUBSTRING( @[User::MyFileValue] , 1 , FINDSTRING( @[User::MyFileValue],".",1) -...

Hi Paul,

i cant understand what u said

plz tell me breifly.and what i did is correct or not

thanks

murali

and it showed below error:

SSIS package "Package.dtsx" starting.

Error: 0xC002F304 at File System Task, File System Task: An error occurred with the following error message: "Could not find file 'D:\sample\rename files\file1.txt'.".

Warning:...

Hi Paul,

i tried using For each loop Container and file system task below is the what i have done in tasks

foreach loop container:

-----------------------

enumerator: for each file enumerator

folder = d:\sample\renamefiles

files =...

Hi Chinna,

i have flatfile table it contain duplicate records.my requriement is elimante duplicate records at the same time load duplicate records in another table.so based on my requriement i have...

Hi paul,

sorry, i cant understand what u said

plz tell me detail

thanks

murali

Hi Jack,

i am new to ssis.i have no idea about to get filename into variable and how to process it.

how to use file system task to rename file tell me...