Yes i have send mail task in On Error event of package,

but it didn't

Does it surely work even it fails source connection or any type error?

Best Regards

asini

Hello GSquared,

i applied SUBSTRING([DateString], 1, 6) + SUBSTRING([DateString], 9, 2) it is working fine, given by Todd

thank you for your valuable response

Best regards

bujji.

Hello,

here what i did was, took one Data flow task, in the Data flow task, have one Source file manager (as locale ID=UK) then, Flat file destination (US locale)

when i...

Hello Jay,

Thank you very much, it works like a charm (this is what exactly i am expecting )

i appreciate your help and i grateful to you

Best Regards

asita

Thank you very much Kings-Oldhand

its really worked as i need

thank you very much

Regards

asita

with master peso idea it works as below(it may help ful for other users)

SELECT SUM(CASE WHEN Amount < 0 AND TransDate BETWEEN '20071101' AND '20071130' THEN Amount ELSE 0 END),

SUM(CASE...

Hello Lowel,

its got worked with below function

(DT_STR,4,1252)YEAR([Due Date]) + "-" + (LEN((DT_STR,2,1252)MONTH([Due Date])) == 1 ? "0" + (DT_STR,2,1252)MONTH([Due Date]) : (DT_STR,2,1252)MONTH([Due Date])) + "-" + (LEN((DT_STR,2,1252)DAY([Due Date])) == 1...

Hello Lowell,

thanks for you reply,

here i have a small question where can i use select cast functions in SSIS package.

in derived column expressions if i use the...

Hello All,

now as per user requirement they said that they dont want the column headings at all

so no issue.

however i have some idea in my brain (i.e just create a...

Hello Jayendra,

I don't think it should double quote the header part.

yes it is exactly double quotes (because when i clear the Columns name i nthe first row, then no double...

Can any one provide any ideas,

how to eliminate the double quotes in first line

can i write a program which opens the file and removes the double quotes for first line...