Jeffrey -

This is a pretty low priority DB in terms of time for recovery, and in terms of threshold for data replace-ability. And there are few enough changes...

Thanks so much for the insight into the unicode/non unicode as well as the hint on avoiding a Data Conversion component. Just curious, what is the "1252" code for...

Thanks for the input - I went ahead and added a "Data Conversion" Block to the Data Flow and converted my Derived Column back to a non-unicode string before uploading...

Unless I'm wrong, you can't use dynamic SQL from within a function? Please tell me I'm wrong, in which case this might be a lot easier? 😀

I am actually using the table-valued function, but I am using the return table to return the contents of the XML file.

I was able to get the DECLARE statement...

Thanks! I hadn't thought of that 🙂

Sorry about the delay in this - I got distracted with a more urgent need and have only now had time to come back to this.

For loading the...

Great - I had to uncheck the box labeled "Enable Identity Insert" in the Edit Mappings part of the OLEDB Destination part of the wizard.

Thanks!

Maybe I'm misunderstanding your suggestion - but I just tried to follow it, and was unsuccessful.

I named my RowID column [IDENTITY] (SQL added the brackets automatically, which I...

In trying to combine the two subqueries into one, I got this far, but have encountered the error messages:

The multi-part identifier "a.IDNumber" could not be bound.

The multi-part identifier...

Sorry, but I'm not sure I follow... I'm learning a lot just from trying to understand what everyone here is suggesting.

Would you mind explaining a bit further...

I would love suggestions on how to improve my indexing!

Right now I have 3 indexes on my table:

1) A clustered PK index on a RowID column

2) ...

Sorry, but I'm not sure I really understand what you mean. I'm still really new to SQL.

Do you mean defining a user-defined function with C or some...

Thanks!

Sorry for being such a newbie about this, but do you know a good resource on SSIS packages to help guide me through the process of adding these queries? ...