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
ViraBI DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ViraConnect With a Mentor BI 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:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Pawan KumarDatabase ExpertCommented:
Ok, What things you have changed recently ?
0
 
ViraBI DeveloperAuthor Commented:
Have changed the server environment for the parent package
0
 
Pawan KumarDatabase ExpertCommented:
Can you check that change again ?
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.