Expanding on Koen's reply a little, SSIS packages are discrete dtsx files....

Sean Lange (5/26/2011)

Phil Parkin (5/26/2011)

Phil the pedant steps in 🙂

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

It would be...

"This kind of data" does not really cut it as far as a spec is concerned. Also, this is not strictly duplicate data.

So far, my spec would be along the...

Have you considered a straightforward backup/restore?

Open the package in BIDS, then File/Save a Copy ...

Or just copy/paste the underlying .DTSX file.

Check afterwards that the package IDs for the two packages are not the same (if...

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