[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 30
  • Last Modified:

SSIS Data load

Hi Everyone,

In my company we have a existing server 2014 on which our datawarehouse is located. Now we are moving onto 2016 server where i need to transfer the DWH and all the ETL jobs. going forward we will be using it for our reporting. I have successfully moved all the packages onto new server. And now i am trying to run full load on the new server. So basically trying to load the data from first available date in the existing server. For this i have a parent package where i need to specify the parameter for running the etl jobs. (Screen shots attached).

So now i am struck at a point where i am running the jobs, they are running fine but no data loads are happening. And these jobs are executing very quickly. It should atleast take 3-4 days for doing a full data load. I am wondering i have a problem with my package connections. I am confused, do i need to change the target connection for each package manually or can i do it using a configuration manger. (But not sure how can i do it, got to know about it by some doing some research). Can anyone please help me with this issue.

Thanks in Advance.
New-Microsoft-Word-Document.docx
0
Vira
Asked:
Vira
  • 5
  • 4
1 Solution
 
Pawan KumarDatabase ExpertCommented:
Have you debug the SSIS package ? Verify it, Also verify whether the base query is fetching data , it may happen due to the where clause?
0
 
ViraBI DeveloperAuthor Commented:
My parent package is working fine. But if i need to check the data fetching i need to go through all my child packages as the parent package is triggering all of them.. I am confident about the scripts because they all are in production on a different server currently.
0
 
Pawan KumarDatabase ExpertCommented:
Ok, What things you have changed recently ?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ViraBI DeveloperAuthor Commented:
Have changed the server environment for the parent package
0
 
Pawan KumarDatabase ExpertCommented:
Can you check that change again ?
0
 
ViraBI DeveloperAuthor Commented:
I got the issue resolved Pawan. Actual issue was with my batch tables where my packages are dependent on. I emptied the table and ran the package its running without any issue.

Thanks for your time, Appreciated.
0
 
Pawan KumarDatabase ExpertCommented:
Ohh Great ! welcome,
0
 
ViraBI DeveloperAuthor Commented:
Thanks for your time Pawan
0
 
ViraBI DeveloperAuthor Commented:
It made my job worked based on the batch id in that table
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now