Heap tables yes, basically all our indexes except for one is Non Clustered. This is part of the problem. I have inherited it like this

We found that fixing this brings fragmentation down by anything from 0-60 % after doing table rebuilds, after rebuilds we staill have fragmentation on tables and indexes. We are using...

The problem is that the Database is originally from an ETL from a Adabas database, so we have hundreds of tables being created, most of the child tables have a...

Looks like I missed something, is running on same server, the package was running to SQL server destination, which I have started moving away from

I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just pointing to...

I was advised previously that using SSIS for this was not really going to give me a performance boost compared to running a insert into with the case statements defined,...

Thanks will try that, still is strange that SQL Server destination complains but OLE Destination does not. I just read elsewhere that SQL Server destination may be dropped in future...

Hi

I have something very similar but there are nulls involved, not sure how this will affect the script.

The field want to use derived column is a field with say 12...

Thanks, makes sense what you say, I will though then keep the insert into in a SQL Task, as we are adding all the other tables via SSIS, the...

The issue with this really strange data is that I need to get a way to do a fast load of the data if this is going to be possible,...

I see you point but this data is weird and we do have substrings for example for 4,6 or 6,20, so some of the values may in fact be nulls

So...

Would that also work for this Case statement

CASE

WHEN Sample IS NULL

THEN NULL

WHEN SUBSTRING(REPLICATE('0', 9 - LEN(Sample )) + CAST(Sample AS VARCHAR(9)), 1, 3) IS NULL

THEN 0

ELSE RTRIM(SUBSTRING(REPLICATE('0', 9 -...

Does this procedure also pick up Indexes? It does not look like it in the Valid Object type list. How can I add Indexes to this search?

In brief here is what I have

A variable number of tables, each of them have field names ID and Index0, they each also have 1-3 data fields. I need to...

I have had a look at these and nothing really solved the issues in SSIS, I think I need to build this into SSIS, just not sure exactly what to...