Is this a onetime load? I did a test with 10k rows and 90+ columns and was successful loading sample data. However, because it has to process row by...

I believe I can.

Do you have an example of the json data and the table you want to put it into?

Would you call a stored proc from SSIS...

did you find a solution?

Thanks, that worked as expected.

http://www.sqlservercentral.com/articles/JSON/68128/

Has 2008 version

I am not quite sure what you are trying to do. If one cell has a JSON format, what do you hope to do after the function returns a...

I have been using schemas during the last 8 months and like the ability to "group" the objects. One spot I use it is with partitioned tables. I have...

has this been completed yet?

It should. You can test it out by setting the code to force the error:

declare @var tinyint

begin tran

Print 'I do not expect an error'

set @var=1;

if @@error <> 0

...

Not at all, it really depends on your design. I certainly would not recommend it for every solution. Is storing and processing of XML data the best way...

Good question. I have not done any tests if it is quicker to use IF ELSE or CONTINUE. I used CONTINUE because it made the code easier to read...

I have been using this for quite a while, although not as complete as it is now. In order to maintian compatibility with earlier versions of SQL Server, I...

Check out transparent data encryption now available in 2008. If this does not meet your needs please read Micheal's article and all the threads. One issue with the...

Thanks for the replies. This thread was intended for the SQL 2000 DBA Toolkit Part 1 topic, somehow I messed up.