Got it

Refresh tables across environments using SSIS

Created: Dec 12, 2020 04:29:40Latest reply: Dec 12, 2020 04:52:07 334 3 0 0 0
  HiCoins as reward: 0 (problem unresolved)

I am trying to refresh two tables from a higher environment (UAT) to development. Both environments reside on different servers. As the refresh is to be done every month, I am automating the process. The SSIS package fails despite all permissions.

Background:

  1. Tables - dbo.A and dbo.B

  2. Database - myDB

  3. Servers - SrvD [Dev] and SrvU [UAT]

  4. Service Account - refresh

  5. SQL Agent Proxy account for SSIS package run is available on SrvD.

I have written a simple SSIS package containing two sequence containers each for a table. Each container contains a truncate, DFT to copy data, SQL Task to log the refresh activity. Once entire process is complete, send out an email to the downstream system. I have scheduled this package from a SQL Agent job.


Featured Answers

Recommended answer

olive.zhao
Admin Created Dec 12, 2020 04:52:07

Can you share your product?
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Dec 15, 2020 03:25:34 (0) (0)
Sorry, are you use myDB?
myDB is not a Huawei product.
If you want to know more detail information, you are advised to contact the local TAC.
https://e.huawei.com/en/service-hotline-query
Thanks!  
All Answers
Hello, dear! It's nice to meet you in the community. We're working on your problem. Please be patient.
View more
  • x
  • convention:

Can you share your product?
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Dec 15, 2020 03:25:34 (0) (0)
Sorry, are you use myDB?
myDB is not a Huawei product.
If you want to know more detail information, you are advised to contact the local TAC.
https://e.huawei.com/en/service-hotline-query
Thanks!  

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.