Skip to main content

LEARNING SSIS

LEARNING SSIS

RESOURCES, COURSES, TRAINING AND CHEAT SHEET

1 Introduction

This document intended for learning about SSIS. Learning resources, link to document and also cheatsheet for project based on SSIS.

I don’t know where I should obtain about courses and training, maybe I need to create it myself for further use.

2 Installation

I did the installation earlier but I forgot the step. With Visual Studio 2019 installation wizard you can get SSIS. I think it also need to install some tools.

3 Learning process and resources

You need to do a lot of reading to understand this tools, and also a lot of practice. But first we need to read the documentation for microsoft web site.

I found tutorial for SSIS in microsoft websites

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-tutorials?view=sql-server-ver15

also on other website, this one contain so many tutorial check them out

https://www.tutorialgateway.org/ssis/

I think its better to learn from microsoft websites because its cover every basic thing, except handling error.

first try (SSIS, flat file, postgreSQL )

I did the tutorial first with flat file and postgreSQL it turn out that even if we can connect to postgre using ODBC the driver can’t detect meta data information from database. After that I try using sql rather than auto detect the table from database. It works. We can connect and get data from ODBC with sql command.

After that we move to using lookup data. I try to connect look up to postgre but it turnout only OLEDB connection being provide by SSIS so I guess we can’t use ODBC. There is using cache connection but I don’t know how to use it. So I give up there. Also there is option using free trial plugin from devart to make everything works. Since it’s not open source or free I gave up again.

This happened when I try to use ODBC and load table using preview


but it works fie if I use sql

but it’s different with ODBC destination tools, because ODBC destinantion tools didn’t have sql field to get data for mapping purpose.

I have look it up on google and also stack overflow. It have answer but I did not know how to implement it. Here is the link

https://stackoverflow.com/questions/49978007/unable-to-select-odbc-source-in-ssis-lookup

For the next trial and error I will use SQL SERVER Express that free from microsoft.

2nd try

/** work in progrees **/


Labels:

Comments

Post a Comment

Popular posts from this blog

JavaScript Real Time Calculation

I've been around looking for javascript that can do Real Time Calculation. javascript real time calculation, javascript real time calculation textbox. by some lucky keywords i found this code. this is exactly the code that i want. it really do the real time calculation. and it doesn't need onChange or OnBlur function. Just try it Example + = this is the javascript code <script type='text/javascript' > function startCalc(){   interval = setInterval("calc()",1); } function calc(){   one = document.autoSumForm.firstBox.value;   two = document.autoSumForm.secondBox.value;   document.autoSumForm.thirdBox.value = (one * 1) + (two * 1); } function stopCalc(){   clearInterval(interval); } </script> this is the html code <form name="autoSumForm">   <input class="right" type=text name="firstBox" value="" onFocus="startCalc();" onBlur="stopCalc();"><br...
3 comments
Read more

writing again

recently after 2 years.... not touching java... ive began to learn it once again. well apparently my friends need to mastering java to get a freaking job. so i just accompany him. i was supposed to do some tutor but i cant do a god damn tutor. me. myself is always learning alone. don't know how to teach someone else to become ME. so i just decide to accompany him instead doing nothing. to make everything start, i have to get some developers kit. so we need netbeans for Development Toolkit. but i don't know how to use NetBeans and i don't know anything bout NB and i don't find any good tutorial for a very beginner in programming. so we buy books. and then again the books not for beginner but still is good enough for me. after this we found www.java2s.com. its almost like a help tools and good thing is everything is so basic and easy to understand. now we used the books from the store and for the help tools encase we don't know anything about something that comesout f...
Post a Comment
Read more

BlackBerry ListField Tutorial Part 2

Blackberry ListField with Clicked Row this time i create based on rtm4bb code. it used manager as TableRowManager to create the field for each row. first i create MenuListField.java
2 comments
Read more