I have a background in computer programming including sql, access, cobol, vb for apps. I worked for a fortune 500 company generating reports with access at the time. I have been a stay at home mom for the last 5 years.
I had minimal training 10 years ago in data warehouse. I took a couple of courses online and understand the fundamentals of using visual studio - creating a package with a data flow, defining the source and target, configuring the connection manager, linking table lookups to the reference tables in the warehouse. I brushed up as i had an interview for a data analyst job that required ssis and ssrs ( I am familiar with reporting tools) - I did not put on my resume but it did state on the requirements. They want to interview me to trouble shoot failed packages. I can figure things out very quickly. However, I am not sure what type of questions they might ask that are more basic relating to ssis and ssrs. I was wondering if you might please be able to provide some basic questions regarding package failures or any questions that might help me get through this. Maybe I am over my head. Thanks again for your help