Phil the pedant steps in 🙂

What you have described is a 'bisection method' - a binary search acts on a sorted array.

Please state expected results for

SELECT *

FROM Structure

WHERE product = 'Part A'

Would you want to see Part Y in the results?

An easy way round that is to use the same file name every time as the destination, but to have a FST afterwards to copy it wherever you want.

The template...

When you have the desired resultset in memory, use .NET to write to an Excel spreadsheet.

For the flexibility which you require, you may need to install Excel on your server...

Not easy at all in SSIS.

Solution 1

Put the query in Excel and bypass SSIS completely.

Solution 2

Check out third-party components such as this one, which might give you the dynamic columns...

You must be joking. Not a chance.

My suspicion at (1) above was right. Something else is failing the package and it's not being reported - the config warnings were only warnings as suggested - I'll investigate...

Please do some Internet searches to get this basic information and then come back here with any specific questions....

I'm tied up with something else for a while, so cannot try your suggestion Koen, but just responding to a couple of the points:

1) Even though those config file messages...

Thanks for the quick response - this is SSIS 2005.

Here is my command line, edited slightly to protect the innocent:

/FILE "T:\SSIS\Packages\abcde\bin\abcde - ERD.dtsx" /CONFIGFILE "T:\SSIS\ConfigFiles\Common\SMTP.dtsConfig" /CONFIGFILE "T:\SSIS\Packages\abcde\Config\Custom - ERD.dtsConfig"...

sanvekar (5/24/2011)

---

First You can Create a data flow Task.(DFT)

In DFT Add task "Flat File Source" and point it to your input text file.

After that Add a task...

Use a table.

..and all occurrences of occurance with occurrence 😀

Ah yes, seen that one many times - well done on figuring out the answer. As the flow can go down either (but not both) paths, each of those constraints...

I agree - a jpg image of the package control flow screen might be helpful.