November 6, 2018 at 9:03 pm
Hi All,
I am new to SSIS and working on a difficult task and need suggestions or advices. How should I find out where the data is coming into packages?
I logged into the system and see there is SSISDB in the SSMS. Now, to find out more about how is the data is coming in( source) I open SSDT and see few pakacges that is all good. The person who setup the system is not available and now how should I figure out from where the data is coming in ERP system? I looked into sql server agent, Report manager and see few reports but no clue from where the data is coming in the ERP system.
The reason I want to find out is to fix a report which is displaying incorrect data. Please do advise me steps or questions I should ask?
Where should I look inside SSMS or SSDT or any other place.
Appreciated.
Thank you All.
November 7, 2018 at 2:31 am
If you want to find out where the data is coming from then best thing to do would be to open the SSIS Project in the relevant version of SSDT. Then, within the relevant package, find the dataflow task and then the data source within there and inspect the node. If the package uses expressions to make the source dynamic you'll need to trace through to where they come from within the package as well.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 8:16 am
sizal0234 - Tuesday, November 6, 2018 9:03 PMHi All,I am new to SSIS and working on a difficult task and need suggestions or advices. How should I find out where the data is coming into packages?
I logged into the system and see there is SSISDB in the SSMS. Now, to find out more about how is the data is coming in( source) I open SSDT and see few pakacges that is all good. The person who setup the system is not available and now how should I figure out from where the data is coming in ERP system? I looked into sql server agent, Report manager and see few reports but no clue from where the data is coming in the ERP system.The reason I want to find out is to fix a report which is displaying incorrect data. Please do advise me steps or questions I should ask?
Where should I look inside SSMS or SSDT or any other place.Appreciated.
Thank you All.
You need to work out which packages are being executed and in which order.
You need to track down any configuration items and environment variable mappings.
Then you need to open each of the packages to look at data flow components and Execute SQL tasks in an attempt to understand the ETL.
It's not really a job for an SSIS beginner, you have my sympathies.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply