There are pros and cons for either option.

If you're storing the files primarily for archival purposes, I would not put them into a database ... why bother?

If you have other...

"If I change the destination of the package to another instance..."

Is that another 2005 instance?

Is there anything going on in the data flow, or is this a straight source -->...

Are you running this in Debug mode in Visual Studio?

Here is some sample code to get you started.

DROP TABLE IF EXISTS #AviationWeather;

CREATE TABLE #AviationWeather
(
    XMLDoc XML NOT NULL
);

INSERT #AviationWeather
(
    XMLDoc
)
VALUES
('<response...

Oh dear, you have 2016 – STRING_AGG() does not work there, apologies.

Note also that your original code does not run – the column widths are not of sufficient size.

Possibly something like this:

SELECT *
FROM #CommaSeparatedString css;

WITH ordered
AS (SELECT css.ID
          ,NewValue = STRING_AGG(ss.value, ',') WITHIN GROUP(ORDER BY ss.value)
...

Our plan was not to store the ISPAC's, but I wasn't sure if they were like exe's.  I know I generally exclude the entire BIN and OBJ folder for C#...

Can you show us the schema of the table you wish to INSERT to?

Do you wish to insert all of the output into a single XML column? Or are you...

My own practices are mostly in line with Tim's.

But don't put ISPACs in source control, for the same reasons you don't put EXEs in source control ... it's a waste...

It's just XML. Try renaming to .txt and uploading again.

Edit: or .XML.

• This reply was modified 6 years, 4 months ago by Phil Parkin.
• This reply was modified 6 years, 4 months ago by Phil Parkin.

Which execution plan?

If you want a set of data to be processed by a stored procedure, could you simply load it into a staging table, then run the stored procedure to...

Do you understand why there would be a difference between the execution plans for

CREATE Proc x AS

Select * from tab1

and

Select * from tab1

? The first is pretty much useless, it's...

Well, that's unexpected ... but I have a solution for you. If you first REPLACE all instances of "" with " " (a single space) before using TOKEN, things seem...

My solution depends on there being the same number of quotation marks (") in every string which is split.

If an 'empty' column appears as "", the solution should still work....