Solved

SSIS Data load

Posted on 2016-11-16
9
12 Views
Last Modified: 2016-11-26
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
Comment
Question by:Vira
  • 5
  • 4
9 Comments
 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41890699
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
 

Author Comment

by:Vira
ID: 41890820
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
 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41890840
Ok, What things you have changed recently ?
0
 

Author Comment

by:Vira
ID: 41891618
Have changed the server environment for the parent package
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41892430
Can you check that change again ?
0
 

Accepted Solution

by:
Vira earned 0 total points
ID: 41892911
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
 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41892915
Ohh Great ! welcome,
0
 

Author Comment

by:Vira
ID: 41896359
Thanks for your time Pawan
0
 

Author Closing Comment

by:Vira
ID: 41902214
It made my job worked based on the batch id in that table
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Expressions are in essence, code. If you had an expression 2 + 2 it would evaluate to 4. A string expression of “Hello” + “ “ + “World” would evaluate to “Hello World”. Expressions are an excellent choice for working with dynamic variables, espec…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now