That is strange.  Generally, that error is accompanied by some other messages.  You checked both SQL instances for error messages and that is the only error message you see?  Not...

Any other errors in the log?  I imagine you are getting some error prior to that one which may help in troubleshooting and pointing you in the correct direction...

DEFINITELY not an ideal solution, but works with the sample data (plus an extra a ways in the future).  It assumes the documentID  is the order in which documents arrived,...

Nice easy question that I actually got hit with recently.  Code that had been running live for 11 years, someone reported it was missing a column.  Went digging and saw...

But from my limited testing, I think that having multiple stored procedures (one for each possible scenario and one "master" one that is used to call one of the others)...

As a thought, rather than handling this in SQL, could you handle this in your import or export tool?  Instead of having multiple "footer" fields, could you concat them before...

Ok, so to sort it how you want, I think this should work:

SELECT CATEGORY_DESCRIPTION
,JANUARY
,FEBRUARY
,MARCH
,APRIL
,MAY
,JUNE
,JULY
,AUGUST
,SEPTEMBER
,OCTOBER
,NOVEMBER
,DECEMBER
,AVERAGE
,STD_DEV
,STDDEV_1_POS
,STDDEV_2,POS
,STDDEV_3_POS
,STDDEV_1_NEG
,STDDEV_2_NEG
,STDDEV_3_NEG
FROM (

SELECT PARENT
,CATEGORY_DESCRIPTION AS CATEGORY_DESCRIPTION
,SUM(JANUARY) AS JANUARY
,SUM(FEBRUARY) AS FEBRUARY
,SUM(MARCH) AS MARCH
,SUM(APRIL) AS APRIL
,SUM(MAY) AS...

Well, the order is likely going to be unreliable anyway as you have no order by clause in there.  If you need it in a specific order, you will need...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

Is the vendor tool dropping the indexes OR are you dropping them?

If it is you, why not disable them and then rebuild rather than dropping and recreating?

Do you need the...

I agree with frederico_fonseca, this should work.  I see no reason why that stored procedure wouldn't work unless you need it to create all of the indexes dynamically in which...

What error are you getting in your backups?  That error message will be the best way to tell what is wrong...

scdecade - will that not fail still if columns don't exist (ie footnote3 may not exist)?  I just did a test on that and, like my solution, SQL sees "footnote3"...

As a thought... if you disable the writing to destination step of the SSIS package, do you get errors still?

I am wondering if MAYBE the problem is on the destination...

I am not 100% sure if IF statements would handle that better or not.  Been a while since I tried it.  Just tried it and it does not work.  So...

My bad... didn't see the attachment.  Sorry about that.

Looking through it now and will let you know if I see something to do what you need.

EDIT - your attached script...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.