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.

steveb is correct. Ignore Kramaswamy's post.

How is this relevant?

I see - that's probably down to good luck in terms of timing. Much better to order things properly and then you shouldn't have these issues at all.

Koen Verbeeck (9/14/2011)

---

Phil Parkin (9/14/2011)

---

I also read an article not too long ago, which I cannot now find (grr!), which suggested that SSIS was the wrong tool to use in...

Sudhir's idea seems the least cumbersome to me ...

Or (and I am not sure whether this is even possible, because I have not tried importing from Access for ages...) use...