"Inconsistent" - indeed. I thought this should generate an error, so I don't get the 1 point.

But this is a bug in SQL Server! Given one often uses...

Could you explain why

cannot use the composite index on Name, Deleted?

Surely as Deleted is in the index, it can be tested in an index scan, without having...

I agree with Bob. What's the point of strong typing if some types aren't?

Setting a Bit value to 500 OUGHT to generate an error. Can the resent behaviour...

[sorry about the double post]

Indeed. Brilliant as BIDS is in some ways, in others it takes me back to the crude tools we had 40 years ago. "Unable to compile. Error...

No. I agree it would be nice if that DID work, but it does not.

Firstly, it's [font="Courier New"]Postcode = Row.Postcode.ToString[/font], and secondly, you cannot apply the ToString method to...

Yes, your query is being built at run time, so at design time there's no information to know to show you the columns, which makes it difficult for you to...

Elliott, even if there's no way to use functions from another SSIS task, there must be some way to use things declared in a separate module, else how would all...

Thanks Steve, that's the solution 🙂

I changed the constraints to OR and NOW IT WORKS 😀

I thought the OR referred to multiple conditions within the constraint;as you say it actually...

Yes, I did have some breakpoints set, but that's not the reason the code did not run.

Firstly, I was looking for them. And I know it didn't run 'secretly'...

The other way to do this ought to be global procedures. For example, in the past when I did everything in VB I'd have a module containing common functions,...

Thanks, Steve; yes I'm sure that would work. And now that I know VB 2008 a little better, I know this form of IF would work too:

...

Assuming you are using a recent version of SQL Server, you'll have SQL Server Integration Services (SSIS). This can handle XML fine.

Regards,

David

Presumably you are loading the file name into a variable from the For Each? (Use Variable Mappings with Index 0).

Then you'll need to work out the table name from the...

Just to warn people about a "Gotcha" when using Fast Load.

I'd split Name and Address off into separate tables, but one record failed validation at an earlier stage. Once...