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

iOS 5 Creating eCommerce with Shopping Cart App Part 1

[Created 11-28-2012] it seems like there are tons of tutorial ios and xcode for beginner out there. you can view the list at my post here http://javalearning-adventure.blogspot.com/2012/11/learning-xcode.html that's the link that i always update if i find anything. this tutorial will consist of step by step in creating Shopping Cart App. There will be Browse Product, Shopping Cart, and Checkout Method. I will update these later after i satisfied with the end result. These tutorial will also include web programming using php. but these php will only using basic sample not the very complex with mysql database and everything. these php pages will only creating json output. i think you don't need to learn php and json. you should only learn how to handle json using objective-c. I am still a beginner in xcode and objective-c, its still only 1 month since i started these tutorial. requirements suppose to be iOS 5 with xcode 4. [i will update these later][postponed...
1 comment
Read more

BlackBerry ListField Tutorial Part 3

This Part 3 will consist of Networking, ListField, JSON and Thread. I'm really sorry for pending this part 3. I've been busy making money and still failed. Its just really hard to live in third world country by coding. anyway, There are few Library that you will need creating ListField with JSON data, but we wont touch that area first. we need to learn the basic. * note added : Aug 26 2013 The basic should be : Networking Thread ListField [if i find anything, will be add here]
Post a Comment
Read more