I think you'll need to write some code. Here[/url] is a starter - you'll have to expand on it to get it doing what you want.

Although it looks like this will work, SSIS is not...

If you can enforce a common column-naming / data-typing format on all of the Excel files, you have a chance of using SSIS and looping to...

Sri8143 (7/5/2013)

---

Implement a function with below logic in an efficient way ...Pass @var1 and return @var2 ...How can it be done as it does table scan now ??

DECLARE @Var1 VARCHAR(10)

DECLARE...

No problem.

Within the SSIS data pipeline, there is not really a concept of table names. The source data values are copied to in-memory variables which then flow through the pipeline...

(clutching at straws...)

One thing worth checking: try changing the tilde (~) to something else (eg 'x'), just in case it is being interpreted as a special character. It does have...

Hmm - that should work.

Can you attach a screen shot which shows the data flow along with the derived column expression?

As long as the derived column is somewhere between your...

Try changing your expression - you do not need the 'select' bit. See here for reference.

Also, note that literal text should be surrounded by " rather than ' in SSIS...

What is this all about?

If your question is about SQL 2008, why not post it in that forum?

If your question is about T-SQL, why post it in an SSIS forum?

What...

Nice work, well done.

Animal Magic (6/28/2013)

---

OK cheers. One theory I do have is setting 3 data flow tasks all output to different files which have the same output path, hence windows seeing them...

I would probably use a Script Component to do this - with a single output column.

The Script Component then needs to take care of adding all the delimiters and performing...

Are the header and footer static or dynamic?

I just had a look at this. I can build a dynamic pivot to get you either 'report count' or 'report pending' figures - but not both on the same...

OK, you need a dynamic pivot in combination with some sort of date tally - that's a bit of work. I'll try to get back to you a bit later,...