Thanks Paul. Seems to be a very partisan discussion. I think I'm on...

Point taken, but however the database engine handles it internally, it's the physically last value that persists. That's what I was trying to get across.

John

This is because you're trying to access a variable called "E:\BINDU\TEST.NEW1.20110707.txt". Surely that is the value of the variable, not its name? I need to see how you're...

I prefer to use standard SQL if everything else is equal. I'm not so bothered about whether it's portable, but it's easier to maintain and less likely to be...

What is the actual file name? Something like E:\DATA\TEST\NEW1_20110707.txt? What is the value of new_a? You either need to make sure that the variable contains the correct...

I actually agree with Joe on this, although not with the argument that it should be avoided because it's not standard SQL. That isn't a concern of mine -...

This is a perfect example of why you should not use UPDATE...FROM. Since there is more than one value for each row being updated, the value will be updated...

Lowell

I think Phil's suggestion is better than using a derived column. But I think the syntax for the latter would be something like this: ((IsHoliday=="True") ? 1, 0).

John

Lowell

The trouble with bit values is that not every provider interprets, as SQL Server does, 1 as True and 0 as False. For that reason, I always stick with...

If you insist on looping in that way, just use an Execute SQL task to get your clients into a variable, then use a ForEach Loop to do the work...

Your details are still a bit sketchy, but given what you've said, I think this is how I'd do it. Write a query that joins the two tables and...

Is there any reason why you want to do this one client at a time? Can you give an example of some rows in the tables, please? Are...

Karthik

What have you tried so far?

John

What do you mean by "understable"?

Use TRY...CATCH to trap errors. I can't be any more specific unless you provide more details of what you're trying to achieve.

John

OK, have you done a search on the error message you get? Here's one link that may help, but you'll find loads more.

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/5e045aaf-2e1a-425b-8e73-b623843cd0ad/

John