Hello Friends,

Can i create a job to transfer data from DW from one server to another server DW?

Thanks 

Ran

Hi Ranjan

yes you can. there are many options available, the best would be to use the Dataflow task in SSIS to move data from your source DW to the target DW. 

Hi Michael

Can you suggent me briefly or send me the links where i can go through it.

Thanks 

Ranjan DS

Hi Ranjan

There are a lot of good tutorials about getting started with SSIS such as this one

http://www.sqlservercentral.com/stairway/72494/

However

I see you asking a lot of questions about a NAV upgrade and migration. This can be a very complicated process and not something a blog is going to solve for you. I'd suggest you get someone who can guide you through the process (Yes this costs money but this is something that can really go wrong very quickly if not done right)

Hi Ranjan,

To achieve your requirement, we should create a SSIS package to transfer data from one server DW to another server DW. Then create a job to schedule the package as a job step.

For more details about how to create a SSIS package to transfer data from one server DW to another server DW, please refer to the following tutorials:
https://msdn.microsoft.com/en-us/library/ms169917.aspx
https://www.mssqltips.com/sqlservertutorial/207/creating-a-simple-ssis-package/

For more details about how to create a job to run the package, please see:
https://msdn.microsoft.com/en-IN/library/gg471507.aspx

Thanks,
Katherine Xiong