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! 😛

Are you saying that the columns themselves are the same, but just that the column names are different?

Or that you want to dynamically select which columns are exported and that...

This might be of interest.

Your sample data is a bit confusing.

Looks like you have a field in the format

<span [text] MM/DD/YYYY</span>

is that correct?

If it is, would it be fair to say that extracting the...

SSIS is not a mirroring tool per...

This link may be of assistance.

Use SSIS and Excel 2007+.

Now please answer the 'TOP' question. I'll spell it out.

Assume you have 10 companies

Company1, Company2, ..., Company10

The first time you run

SELECT TOP 3 Company from Company

you...