IF ( SELECT COUNT(t.name) AS CheckQuery FROM (

SELECT f.name FROM fleets f

WHERE f.name NOT IN ( SELECT C.CompanyName FROM Company C

LEFT JOIN Accounts A ON A.CompanyName =...

steveb. (10/6/2011)

---

This is...

Please describe how to use that within an SSIS package.

I suggest that you read this to help your understanding of scope.

I can't give a specific answer, because that would require me to look into the design of your report.

But,...

Oooooooh, cool!! Maybe in five years we might have actually migrated to Denali 🙂

The error message seems self-explanatory: what is your question?

There's still no hint of a question mark there.

If I said: "I would like a new car," would you know how to respond?

If I said: "Can you for help me...

You have told us what you are doing.

Now take the next step and ask the question, or questions, to which you would like a response.

Maybe in another five years, the answer will instead be "select the desired value from the scope dropdown menu from within the variable's properties" 🙂

It will be there somewhere, as a tab/window - though possibly its position will vary from one PC to another, as the VS IDE is very flexible in the way...

You need the same field in both places to enable you to do a lookup, simple as that.

Unless you are able to find an algorithm which can derive short name from long name, there is no easy way.

One way to solve this permanently would be to add...

Scott Murray-240410 (9/30/2011)

---

We often see this error when the export exceeds the 56k rows; unfortunately, the export still uses the Excel 2003 limits and the error is never clear...

This should work:

DELETE from dbo.ImportStage1

where

Column_8 <> Floor(Column_8)

Oops! 😛