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...

engrshafiq4 (9/26/2011)

---

Please help me in this...

i have more than 100000 records in company table...i want to export in excel and then do some correction and then import again.....i have a...

Not enough detail here.

Please follow the link in my signature for details on how to post questions such as this.

I think you can code round this using IsNull():

avg(DATEDIFF(DAY, o.ocDateOpened, IsNull(o.ocDateClosed,GETDATE())))

You'll be able to do it with an asynchronous Script Component - will take a bit of coding but if you're familiar with VB or C# it's nothing too onerous.