Somewhere is the "Rules" of writting SQL is the one that says once you perform an outer join you can NEVER perform an inner join to that table and expect...

Just a note that may or may not have thrown others off. There was no mention if the header and underline lines were actually included in data file.

I made...

Having worked with this problem before (import of access "money" type into SQL2k) you have a slight problem that is not always obvious. Even though Access says money and appears to...

Thanks Phill

I will take a look at the metods used for future reference. You can never learn to much. The more you know the more you realize you do not...

Julia

Ok, That might work in some cases. I would have to test the retrieve portion also to be sure.

However I am getting a little more complex in my routine...

I use INI file as my main communication method back to calling Package when I have nested packages. DTS is good in forward communication but really bad in reporting results.

I...

This was not mentioned but may really be the problem. If SQL procedure is being called by Visual Basic the problem could be in VB. When the programmer created an...

mccork - you are back. thanks again. I have reposted this Commit=1 vs Commit=0 stream over in DTS where it may be more appropriate.

I, like you have not seen...

To all out there

I have semi found the problem but the solution is not workable.

In original configuration I was committing on each record within the DTS transform. Though much slower...

Mccork

Thanks for come back - the DBCC SHOWContig you requested for the files are below.

As expected the problem is in the data portion not indexes. Unfortunately there is no FillFactor...

Brian Knight  - Thanks for the pointers. I should have known to search SQLServerCentral for answer.

Ok as asked above but not answered - where can you get info on complete list of Trace Flags? Flags are not any good if you do not know about...

Now I am confused. I have a master / detail situation. Master has 1mil + records and is cluster indexed on MasterId Identity Integer field. Detail has 5mil+ records and...

Now I am confused. I have a master / detail situation. Master has 1mil + records and is cluster indexed on MasterId Identity Integer field. Detail has 5mil+ records and...

I found it interesting that the email received had the correct DESC (second choice) but on the website the DESC was missing. This of course lead me to change my...