I had tried that but it didn't make a difference. I also tried putting the right outer join on both dimDate and dimQuotas and that didn't work either. ...

Current update and I'm going to do more with this this afternoon, but I found that if I make the user a db_owner in the source database then all the...

Johnathan,

Thanks for your input. I've read all the links you included and I I'm confused because, as far as I can tell, I am following everything you said as...

I did copy the configuration files and used the manifest to install the packages on the production server. When I did that I changed the values from the test...

Absolutely, makes sense.

So, given the sample data I would expect to see the following in the #repPerfLevels table after the update is run:

INSERT INTO #repPerfLevels (employee_number, perf_level_measure_id, perf_level, min_target, max_target,...

Thanks. All three versions run about the same and there aren't huge differences in the execution plans.

Thanks again for all your help.

That will work. Thanks.

Here is another way. Thoughts on the differences?

SELECT DISTINCT

Score,

expectation,

employeenumber

FROM(

...

Thanks. That was exactly what the problem was. The source system had a lot of char fields and in the warehouse they were varchar. I just changed...

Thanks Ryan. I ran what you posted and believe it worked. Thanks for your help.

Is there a way when importing text files to keep those "invisible" characters out...

Yes, I have. I get the following when doing that.

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value '16954797      ' to data type int.

Thanks for all your help. I think this will help to resolve the current issues. Thanks again.

Thanks. One idea I did have was to do the backups directly to our MSA. However, when setting up the backups in SQL all I can see are...

Thanks for your help. I went ahead earlier this morning and ran a shrinkfile command through SSMS and the file shrunk to about 5.1G.

I then ran DBCC SQLPERF(LOGSPACE) and...

OK. Thanks again for your help.

Thanks GSquared! I do have a numbers table and this solved the issue I was having. I do want to get clarrification though so I understand what is...