Thanks SSChampion detailed steps, i will try to implement it,

I have  created Staging table but when loading from Staging table to my regular tables and inserting FK values from parent table, FK field not loading all the PK Field...

Thank so much Alen.
Please see the following Query 
CREATE TABLE [dbo].[StagingTbl](    -- Source MAster Table
    [D_Cat] [nvarchar](50) NOT NULL,
    [QAP] [nvarchar](50) NOT NULL,
    [F_Cat] [nvarchar](50) NOT NULL,
    [Prog]...

Thanks for your reply.
I think Import wizard only allow to load into single table, mot multiple table, right?
I already loaded into Temp Staging table but i was also...

Thank you everyone for your help and response.
I was able to trace using EventLog and through TAsk Manager and it helps me out.

Thank you!

Any other tips?

If any one has any input, really appreciated.
One of account looks like is a service account but that one also associated with other databases so i can't remove or...

Hi,
I am curious for TDE implementation as we have our data center at other location where we replicate our data so if we implement TDE then what will happen...

Thanks Gail.
But I need TEST Login and permissions which originally i have it so i should generate login script from TEST before Refresh and after Refresh, I should run...