I think this will meet your requirements based on the information you provided.

WITH tests

AS (

...

Lynn Pettis (5/29/2013)

---

CheeseheadDBA (5/29/2013)

---

Hi all,

I have a question I hope the community can help me with. I have a query that is running against a legacy system. I...

Sounds like that is at least part of the problem. Are you allowed to do any maintenance on the database?

You should also check the auto update statistics setting on...

deandvorak (5/28/2013)

---

Oh, that's the easy way, and the way I would've done it, being a newbie myself. I wanted to see how you would delete each row after it was...

Did you update statistics after upgrading the database?

4000 rows shouldn't take 4-6 hours to import even with RBAR.

Can you share schema and queries?

Okay. Here's one way to do it:

Data Flow that transfers/processes the data -> On Success (using default settings this would mean all rows in your Source have been successfully...

A named instance on a windows server is technically not the local SQL Server instance. A local SQL Server instance can be connected to from the windows server by...

Can you explain more about what you mean by process the json string? Are you parsing the string to populate multiple columns?

Is the source table in the same database...

No you cannot avoid making the change. The SQL Server Destination only works if the destination is on the same server as the SSIS server. From BOL:

The SQL...

Santosh,

This has nothing to do with...

You need to change the column id parameter to the one you need.

SELECT

*

FROM

sys.trace_columns AS TC

WHERE

name LIKE...

Sounds like either your mapping is incorrect or the CSV isn't right. Without seeing the package and the CSV file hard to say for sure.

SET STATISTICS XML ON;

Yeah that totally sucks, because even if you have a process that archives off the older trace files you'd probably be missing some in this case.

Reading the link Eugene provided will definitely help get better answers but here's something that I hope will help:

Select

Count(I.investorid) as investors,

F.fundID

From

...