Another tricky (not intuitive) thing with Booleans in SSIS when coming from T-SQL is that you do not need to do any equality test. Consider something that looks like this:

@IsHoliday...

See if something like this works for you:

CREATE TABLE #tmp (errorcount INT) ;

DECLARE @sql NVARCHAR(MAX) ;

SET @sql = 'select 1 as errorcount;'

INSERT INTO #tmp

...

You don't need to access the instance...

One other angle to consider that helped me...a SQL Server BIT is an exact numeric data type, however once in SSIS it maps into a .NET Boolean data type which...

The instance hosting the SharePoint databases may not be configured to allow remote connections.

The section titled Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition...

You're receiving the error because you are not in the sysadmin Server Role. Someone may have granted you exec permissions on xp_CmdShell however they did not setup the xp_CmdShell proxy...

Anything you can do in declared T-SQL you can do with Dynamic T-SQL...so is what you're trying to do possible, yes. As for achieving it, it will be a...

Check constraints? How would linking to MySQL using ODBC provide any advantage over MySQL dump?

Thanks for posting back, happy you got it sorted 🙂

I just tried this in...

amy.walsh (7/6/2011)

---

Hi there,

I'm so close, and yet so far... I am looking to report on validation rules -- that is, record how many records break the validation rules...

Bruce W Cassidy (7/6/2011)

---

Can't remember whether it was introduced in SQL 2005 or 2008, sorry.

Now, if you really wanted something to think about... try thinking about being able to...

In short, yes, but there's more. Service packs are more than just your average patch. Some contain major new features as well as major patches for existing features. It will...

I have thanked you many times before in these forums and it goes without saying that there were no doubts as to your deservedness but I must say it too,...

Here is David's code with a couple syntax errors removed and then reformatted:

WITH cte ( Invoice_id, IssueDate, Account, ApproveDate, RowId )

...