Further on Jeff's answer, are you experiencing similar behaviour with other activities on this server? And other servers on the same network?

😎

My suggestion would be to use a Stored Procedure on the server, a SqlCommand object, set each parameter and exec.

😎

Next question, can you somehow test if this connection works outside the script task as if it doesn't then obviously the script task code will not work?

😎

Quick question, why are you using Script Task instead of ExecuteSQL for this if you have the values in local variables?

Second question, is the ADO.NET Connection correctly configured?

😎

spaghettidba (1/29/2015)

---

I don't think this is enough to exclude symbols and other characters...

Quick solution which excludes any columns with a character after the column prefix

😎

SET NOCOUNT ON;

USE tempdb;

GO

IF OBJECT_ID(N'dbo.TBL_COUNT_COLUMNS') IS NOT NULL DROP TABLE dbo.TBL_COUNT_COLUMNS;

CREATE TABLE dbo.TBL_COUNT_COLUMNS

(

field1 ...

prasadau2006 (1/28/2015)

---

Hello Friends,

I need help with the following query, this query is taking more than 20mins to complete. I'm using a left join to

pull the data.

Query:

Insert into dbo.SecondTable

Select b.*...

Quick answer, you...

Jeff Moden (1/23/2015)

---

Thought I'd throw my tweaks into the ring.

DECLARE @PassedInDate DATETIME;

SELECT @PassedInDate = '15 OCT 2014'

;

SELECT Wk# = ROW_NUMBER() OVER (ORDER BY wk.MondayDate), wk.MondayDate

FROM...

Quick thought, is TCP/IP enabled?

😎

Quick thought, the problem doesn't require a complex table structure, something like this should do

😎

+----------+ ...

Quick thought, seen this behaviour occasionally on SQL Server 2008, caused by an implicit cast or at least adding the N'' has fixed the problem.

😎

Try changing

convert(xml,'<xml><![CDATA[' + cast(TABLE.COLUMN...

GilaMonster (1/23/2015)

---

Or, if you want to be even more confusing...

create table [where]

([where] char(5),

[from [where] varchar(25),

[select [where from [where] varCHAR(50),

)

go

insert into [where] values ('from where', '[from [where]]', 'select...

Removed bad solution

😎

Quick question, can you post the DDL and some sample data as an insert statement, makes it easier to help?

😎