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

MySQL and Java Developer's Guide

Now we begin the second book and thats called MySQL and Java Developer's Guide. Book before this is quiet advance for beginner but still for beginner. And i notice that previous book had only 4 chapter. Ill read that book again. Okay Lets start. This book consist MySQL and Java plus Connector/J that connect Java to MySQL. This book is perfect for beginner but not beginner in programming. I think that this book is a hardcore book. Everything they wrote even if they use GUI Object like form and button they only use a "Notepad" or should i say "Text Editor". i really love this book. From this book you need to install three things to make the code in the book work. a. Install mySql b. Install Java SDK @ http://java.sun.com/j2se/1.4.1/download.html. c. Installing Connector/J @mysql.com version 3.0 thats from the book. I use this : jdk-1_5_0_11-nb-5_5-win-ml.exe notice the nb-5_5 that means itll install netbeans 5.5. netbean 5.5 is IDE for jdk 1.5. its devel...
Post a Comment
Read more

Trying IBM Cloud Foundry with Go

  Pre~ So sometime ago I try to search free host for Go and found out that IBM Cloud gave free stuff on their system. I went and try but didn’t read the document too much, I’m just excited to try the GO server. I’ve been learning the buffalo framework for a while then I have to stop because got injured in my ankle and try to rehabilitate them for a few month so I can walk again. Anyway I found free stuff from IBM then I just want to try it out. This writing is just a documentation for me and anyone who see it useful. I didn’t try to write a very detailed or well edited science stuff. This document was meant to be a small cheatsheet for future reference. IBM CLOUD DASHBOARD If you already registered and logged in, you should be redirected to the Dashboard. If you see the menu  from image below you’ll notice there are a lot of stuff ready to be explored. Now I just need to find where I could upload my GO code into server. Anyway I chose the Cloud Foundry just because its o...
Post a Comment
Read more