I'm not sure if the OP's original question is to find schools that have

ONLY and ALL of the courses in the criteria (e.g. 'maths' and 'english')

or to find schools...

Right... execute SQL Task. Sorry about that. I'm glad it helped, though!

PSS

Matt,

Read my post, above. Basically, a spreadsheet is like a database, and a worksheet is like a table. With an Excel connection in SSIS, you can pretty much do...

There IS a way to do this in SSIS. I assume you already have a connection defined for your Excel file. Using this connection, you can clear a worksheet in...

Can you share the solution with us?

Thanks

Try this. It uses a Tally table. If you haven't used a Tally table, see http://www.sqlservercentral.com/articles/TSQL/62867/ for how to build.

;WITH cteTanks

AS (

SELECT

m.actual_date_time...

If I understand correctly, Table B has a composite key of Id1 and Id2, each being a value in one or more of Table A’s primary key.

Do you have the...

I just finished reading today's featured article on using SQLCLR for exporting data to flat files (http://www.sqlservercentral.com/articles/SQLCLR/65657/).

Does SQL 2005 64 bit support this?

I'm not completely sure why the "char" parameter isn't working. The table field "LastName" is nvarchar(50). A "char" can be implicitly converted to an "nvarchar".

But converting your "char"...

He is executing a .txt file

When you create a DTS package, you can either save it to the Server, save it to a Visual Basic File (.bas) or a Structured...

Please post the contents of logDTSCentralizado.txt

How, exactly, did you execute the DTS package?

With DTSRUN command? Please provide the command (without security parameters, of course).