The problem with using natural keys is that they can change. Suppose a VersionNumber is added to the table and becomes part of the natural key. The index upheaval would...

Okay, I resolved this in such a simple fashion that I'm embarrassed that I didn't think of it sooner. Each record has a type number, i.e. 1 for header, 2...

Uh...no. One file, one 490 column field called TextData. The file is for exchanging fixed length data records.The columns have all been concatenated into one 490 character string. This is...

I saved the XML as a txt file. Hopefully that's good enough for you.

Not sure how to do that as I can't upload an xml file or a dtsx file.

We learned some hard lessons that these charges can add up fast. We found out we were spending $5 or $6,000 a month simply because azure machines were left up...

Yes, couldn't have mapped it otherwise. I have made a copy of the database I coded against and placed it on the server the job is running against. The connection...

Thanks for the help everyone. Ultimately, this is what worked.

DECLARE @cols AS NVARCHAR(MAX),
   @query AS NVARCHAR(MAX)

SELECT @cols = ISNULL(@cols + ',','')...