I am not fully as familiar with SSIS yet. I have made a few packages, but I really have no more than the most basic exposure to it. After reading...

Issue update:

I was able to isolate the login fails issue. There are 2 SQL Server(MSSQLSERVER) kind of instances on this server (one by the standard name, and one with our...

Does it matter if all I'm trying to do is have a daily backup, not a point in time back up? I can remove it, but I would like to...

Separate file's each day, got it.

As for why I was switching to Simple before the backup, it is a bad habit of mine to explicitly define all the options each...

As part of my signature so eloquently says, "DOH!!!"

I missed the With File = 4 during my restore. Thank you for catching that.

Now to touch on the best practices part....

Correct, they are 2 steps. Running step 4 will populate data needed for step 5.

Ok I just looked like I didn't know what I was talking about on part of the question in my last post...because I didn't know what I was talking about...

05 Import To Loan Account should populate dbo.LoanAcct with all 5306 records.

What I'm seeing is a massive delay in the processing time from 04 to 05.

I made the requested changes.

Ok, to do this with all my cards on the table I have altered the scripts to remove any identifying company names, etc.

Create a database called VanGogh_Dev, then run the...

Ok, here is the full script:

If Object_ID('dbo.Loan_Stage') Is Not Null

Drop Table dbo.Loan_Stage

Go

------------------------------

--=== Populate dbo.Loan_Stage with 1 version of the

-- LoanNum / CustomerID combination. Keep...

So the snag might not be in the code I referenced above. I just ran another update on another table using the same logic. I had to complete updates on...

Sorry, I just saw that I forgot to include a vital part of my logic to why I am doing things this way. I have a transactions table which shows...

These are great questions. Let me see if I can explain my logic.

Client 1 Offers

Product 1

Product 2

Product 4

Client 2 Offers

Product 2

Product 4

Product 5

I want to be able to run reports...

Thanks for the reassurance. I'm designing a new financial tracking system as the company's new DBA...and I'm trying to do this as perfect as I can from the start. It...