Let's start with the basics:

can you somehow verify that the used credential has actually access to the other server?

quasar_phoenicis (2/9/2011)

---

hello,

so i have a query that selects a min date in my sql 2008 database that resulted to 1750-01-01 00:00:00.0000000 (datetime2 data type). This query is being executed in...

All that trouble to make a nicely formatted hyperlink 😀

Can you try setting the ForceExecutionResult property of the Execute SQL Task to Succeed?

Nice question, thanks.

What is it with Microsoft and giving names to products?

IF EXISTS (SELECT TOP 1 *

FROM Tempdb.dbo.sysobjects (nolock)

WHERE name LIKE ''##TUser%'')

DROP TABLE ##TUser

Is there a reason why there are two times single quotes around TUser% in the LIKE clause?

If...

Ah. Glad you're back. This discussion is so much less entertaining without you.

Why are you using EXEC to execute your statements. You don't have dynamic SQL, so I don't see the point.

Furthermore, it is possible that the statement within the EXEC is...

Is the Integration Services service running on the same server as the destination table?

Great! Glad that if finally worked out.

Thanks for posting back.

For all those kilt wearers...

pmm.sudarsan:

It is much easier to just set the DelayValidation property of the dataflow to TRUE.

This way, validation will wait until the dataflow starts running. By that time, the table is...

What happens when you try to start the service in SQL Server Configuration Manager?

I'm afraid you...

What I usually do:

1. Read from the source

2. Perform a lookup on the ID and take the ID with you.

3. A conditional split that checks if the ID from the...