Good stuff about dealing with big files, but for the delimiter it's easy enough to set LF rather than CRLF in the file's connection object. I do this for data...

Hopefully the last question:

I've started building my triggers. The first is:

CREATE TRIGGER ChinaSecurityTypesInsert ON [dbo].[ChinaSecurityTypes]

FOR INSERT

AS

INSERT INTO dbo.Operations (TableName, PKValue, OperationType, Detail)

SELECT 'ChinaSecurityTypes', ChinaSecurityTypeId, 'I', NULL FROM INSERTED

This is...

Thanks to everyone - what a great response.

None of this is for significant scale OLTP, so the reason I am shy of triggers is simply that so many people forget...

It's just really that the developers won't have the discipline and might push back a bit. Whenever I've done this as a developer it wasn't too bad, but then I'm...

I think this works like any other tariff. I only have first year university economics, but the simplified stuff they tell you at that level is that tariffs end up...

We'd really know if the market wanted new features if they still sold old versions of software alongside the new ones, at reduced cost. Of course, few vendors will do this because...

If the value you want to set is the output of a stored proc, can't you just use an output parameter on the Execute SQL task? It's a while since...

Might be nothing to do with anything...

But why does the batch file run the desktop menu shortcut to Excel rather than the Excel executable? This adds another piece to your...

As a developer of software for use in-house, I'd agree with what I think is Chris's subtext - if there were SQL Server memory leaks we'd be likely to know...

This has been a problem for me too. I have loads of packages which call others, and currently they run on a hit and hope basis.

I think a solution is...

1) Choose VBScript or Java script. Everyone I know outside an institution chose VB...

2) Either:

a) buy a VBScript book, or

b) read VB tutorials on the web and ignore 80% of...

I'll add a bit more because this did confuse me when I started with DTS. The simple thing to do is create a new package with the designer, and add...

Without wishing to assume too much about the task, this does sound like a row-based vs. set-based problem. I agree with Jonathan's first post up to a point - bring...

Having been both sides of the interview desk, I can see both sides of the argument.

I've had candidates who can give chapter and verse with technical answers learnt out of...

From the colleague's perspective, I do get zero. So it must be a permissions thing. I think we have a tidy-up to do; our Operations team is supposed to have granted...