Thanks. You've answered the question in bold - please will you now answer the others?

Please post the exact error message. Is the Execute SQL task the only task in...

Please post the exact error message. Is the Execute SQL task the only task in your ForEach Loop container? Is the table it updates on a central server,...

OK, you've shown what results you need, but you haven't said in what way what you currently have isn't working. I would guess that your col1 looks more like...

I'm not 100% sure I understand your requirement, but does this point you in the right direction?

REPLACE(@EmailAddress, CHAR(146), '''')

John

Sean Lange (6/6/2016)

---

And let's consider the table valued function that uses a cte. If you slap a semicolon at the beginning doesn't that now make what could have been an...

You can try it for yourself. Set up an extended events session, capturing the lock_acquired event, then run your delete statement. You can then inspect the captured events...

I think that's about as concise as you're going to get it. As you'll have noticed, string manipulation isn't one of T-SQL's strengths. If you're going to be...

Good. In that case, sounds like you're using different credentials in the package from those you're using in SSMS, or the connection manager specifies a database that doesn't exist.

Is...

How are you running the package - interactively in SSDT/Visual Studio, from a SQL Server Agent job, with dtexec, or something else? Can you ping Server B from the...

Look in the ExecutionLog table in the ReportServer database, and compare the time to run the query with the time to render the report. This will give you an...

Yes, maybe Named Pipes is configured in a non-default way. Try creating an alias that connects with TCP/IP and specify that as the alias in the properties of SQL...

What protocols (Named Pipes, TCP/IP etc) is SQL Server configured to use? You can find this out by looking in SQL Server Configuration Manager.

John

Possibly login failed for the account that runs SQL Server. Does your SQL Server errorlog capture failed logins? If so, have a look and see whether there are...

Difficult to visualise without any table DDL or sample data, but what you want is a snapshot as at the end of last month and the end of the previous...

You asked about formatting the output. What you do in your WHERE clause doesn't make any difference to that. But the WHERE clause you posted doesn't contain any...