Guys Thanks to all....Looks like this piece of code seems to work....

here is the whole codeAS

SET IMPLICIT_TRANSACTIONS ON

SET NOCOUNT ON

DECLARE @ERRORNUMBER INT

DECLARE @ERRORSEVERITY...

@vmavoodu - Please see above, my first post has error message.

Since Steve, suggested me to put only part of the code I took everything that was within begin and end...

SOrry Steve..I thought posting everything will help more clearly to look @ the code, bUT i think I was wrong.

here is the codeSET NOCOUNT ON

DECLARE @ERRORNUMBER...

Ken thanks....As a Matter of fact I was working on it rt now.

*******NOTES: I didn't realized that I am doing Insert too. But the INSERT is not on T1 table...

David, if you are talking about my code, then it seems it will not help for your second scenerio. ALL my function does is - removes spaces bewteen two or...

Guys thanks to all. Everyone seems right except the one where he is only thinking about this particluar string. There might be different ways when data comes to me. The...

Thanks MC.....It worked becoz u have two rplace there to take care of two scenerioes. But we don't know how it comes for other rows from mainframe. Rt now I...

'A COSMETOLOGIST uses knowledge to do things to a client`s hair. A HAIRAPIST uses knowledge to give a customer guidance so she can do her own...

DELETE FROM mytesttable

WHERE (CONVERT(VARCHAR, datevar, 103) = ?

I have used a input parameter whose data type is DBTime

This input parameter is a user::variable whose datatype when i created was...

keywest u r confusing man..

post some data and the reults u trying to get. and alos get into details what u trying to do....

Try this

"insert into MyTable(column1) values ('" + REPLACE((DT_STR, 25, 1252) @[User::XMLTestVar1], "'", "''") + "')"

I have a ssis that logs on error on event handler. and I have used this...

Marios, I think something is going wrong @ ur SSIS. I have a ssis package that loads over a 8 millions rows in less then 15 mins, to be exact...

ps thanks...But looks like i confused u. I know I can easily do in T-SQL.

But the problem is i need to do this inside the dataflow task in the...

I said many times to myself that i am not gonna reply tothis thread. But, cannot hold anymore as I receive email everytime there is reply from u all. But...