SSIS stop warning same user when opening package

Today I have an assistant to help me how to create package by using SSIS

but He have got the problem when he tried to open the package was created by me

It have error such like "The owner who created these package were different from the one who are using"

He have to clicked "OK" about 20 times to accepted those warning!

That made me not happy for this situation then I tried to find the solution from website but seem like no body ever met with this problem like me before

Then I have to asked this solution from an other developer, He suggested me how to solved that problem and unbelievable, It work!

STEP-1
Please see the error as it showed me on the popup

STEP-2
Close Visual Studio program that, and open it again by click right on the menu on the name of program "Visual Studio" then select "Run as administrator", This is help, even at the first time you have to accepted "OK" but after you save package and close window then always run Visual Studio as Administrator, This 's way can help you feel stop to upset. ^_^ 

Have a great day and enjoin life!

Read More

Change Data Type in SQL Table

No No No!
I tried several times to changed my data type in table of SQL Server but it was always said "Could not save!"

I was wondered why? I ever have changed the data type in MySql table very simple by click on the field and select the data type as I wanted but for SQL Server I could not do like that.

However I have a solution ^_^

STEP-1
Click on "New Query"



STEP-2
Fill your code as details below but please change tb_name and field_name as your table data, nvachar(20) and int(10) they are new data type I wanted to change.

ALTER TABLE tb_name ALTER COLUMN field_name1 nvarchar(20)
ALTER TABLE tb_name ALTER COLUMN field_name2 int(10)

STEP-3
Click on "Execute" and now your data type field have changed to the new one as you needs ^_^

Special STEP Simple

Go to Tool -> Option -> Design then remove checked list as detail below
- Warn about different detection
- Warn about tables affected
- Prevent saving changes that require table re-creation

Read More

Change blogger to real your domain name, very simple!

THIS IS FOR SETUP WITH GODADDY ONLY !
Wow! I can say it was such a wonderful site for me to create a personal website just spending time only one day or maybe more or short that depend on your skill and environment too ^_^.

After I knew about blogger.com I fail in love this tool so much because I can have my own website and post simple content as I needs.

However blogger it suitable for website developer who do not like more complicated and if you know a bit about the website you can have your own site in one day!.

And now it such so amazing! you can have your own domain instead blogger.com for the last name. You do not worry to have long last name on your domain name such as www.mymemoboxs.blogger.com, We can change to only www.mymemoboxs.com, That sound pretty cool! ^_^

Okey! let's see what we can do to make the personal domain name on google blog.

STEP-1
Please make sure that you have already have gmail account then you can use any tools of google products and for this details, let's me skip please ^_^ then go to our topic, Okey! after you have create your own blog with blogger.com and sign in and click on your blog name as you had build and click at "Setting", The menu tools on the left site of the page, you will see the page set up as below



STEP-2
The page will present you in basic default setting, Look at Blog Address, now you will see your full domain URL and have the last name is blogspot.com, Fill you domain name in Blog Address for example  "mymemoboxs.com" then click on "+Setup a 3rd party for your blog"




STEP-3
What you will see after click on "+Setup a 3rd party for your blog", blogger will generated code for put in CNAME on your domain name configuration as below, You have to copy those code to add on your CNAME, for me I have register my domain name with godaddy.com,  I loves it because very simple to use however I also do not like some thing after they have changed style, There are many too popups, Okey! now go ahead with our job.

STEP-4

You have to sign in to Domain name site for add CNAME, I guess other domain service site will have this feature too. And here it's a godaddy style, Go to "Domain name" management , Click on your domain name that you have register

STEP-5
Click on "Add Record"

STEP-6
Selected option on CNAME,

STEP-7
Copy code from blogger.com as STEP-3 at line number 1111, We need to add
"www" in Host box and number 2222  add in Point to box, That not finish yet, you have to edit an other CNAME after save

.WARNING! Please save all alert godaddy remind you and also click on "Finish" too

STEP-8

Edit www CNAME, the default of godaddy it was set to www in Host box and  @ in Point to box but now We have to change to an other one instead here, leave www as it was ever been but for @ replace it by "ghs.google.com" and save


STEP-9
And now every look perfected, You just return to your blogger.com and go to "Setting" menu on the left hand again, Fill your domain name then click save, and now you can go to your website by use your own domain name as you wishes ^__^ CHEERS!!!
SEE! before you need to wrote www.mymemobox.blogger.com but now I can go my site by use my own Domain name is www.mymemoboxs.com, It's such a pretty cool!

Enjoin your code and Enjoin your life ^_^

Read More

SSIS Convert Data From MySql to SQL (Thai Language and Other )

Oh! My God! If we do some thing in first time, It quite hard for us but after we started walking then running it was easy for us ^_^ do you agree with me? I spent about full day to find the solution to fixed my Thai alien language in database, Every things look perfect in MySql database but after I have transfer all Thai data to SQL server why it SUCK!!! (OOP! sorry I was rude but T_T it because my pressure for a day to searching solution) I am guarantee if you do all step as I suggested you will do not miss beside you do on wrong way ^_^...then go ahead!

My Thai Character before convert data in SQL DB

STEP-1
Set up your region as the language you are Click here for more details 

STEP-2
Be sure that you have to configuration character on ODBC is tis620 (For Thai language and for an other language please choose your) Click here for more details

STEP-3
SQL server are the same character set (For this step let's me skip please ^_^ but I guess it will not too difficult)

STEP-4
Open SSIS for develop to transfer data from MySql to SQL server then click on your job
As the image below I pick up ADO Net Source because my source database is MySql, I have tried choose an other one but that did't work.

STEP-5
Drag and Drop "Data Conversion" on your window job for convert type of data, Then double on box data conversion

STEP-6You will see the popup window for you to pick up the data as your want to convert, Then change the data, almost text from MySql have to convert to Unicode String and be sure in your SQL database have already set data type was "nvachar".

STEP-7
Map data to the new one (Double click on OLE DB Destination, then click on "Mappings") , After you have set convert data to the new one, SSIS will automatic create new field for you immediately like "copy to thainame", please see image below

STEP-8
Now LET'S GO!! run your process then you will see the magic ^_^, now you can read your language
Congratulation with you too!!

Read More

Character Setup for Transfer data from MySql to SQL Server

WHY!!!! my language it was an alien after I have transfer data from MySql database to SQL server? Yeah! I know that many developer was upset when it was not as we wished, I have set tis-620 at my MySql database and I also did the same on SQL server but WHY!?. OKEY! please clam down and I have a solution for you, Just do it carefully by step by step then I am guarantee that you will get the answer and I am sure for an other language it will be the same, you just need to change character as your needs.

STEP-1
Go to control panel on the window menus

STEP-2
Find "Region" menu but if you do not see please change your view to small icon

STEP-3
Then you will see the popup window as photo below then click on "Administrative" tab

STEP-4
Click on "Change System Locale...", Exactly the default will be "English" if you installed window and choose the language as English or depend on your choose, You have to selected language as you want (In image I have to selected Thai)

STEP-5

You almost be done! ^_^ just click "Ok, Ok and Ok" then Restart window but my Warning is please save all jobs before you have to restart, I confirmed that your Thai language or any language will be fine after you have transfer data from MySql to SQL Server if you miss that mean you were wrong XOXO ^__^ and please set ODBC to tis620 or character code as you needs too. Click here for setup ODBC Character

STEP-6
For more add-on, If you have to transfer data from MySql to SQL server by SSIS you have to set conversion data, Please see in next stop by click on here

Read More

Config ODBC for connect to MySql

Yo! I know that it not easy to the beginner to try to configuration ODBC to connection to MySql and for be sure and I will never forget all knowledge as I know I'll tell you step by step, Hope all will help you Okey! let's go to step one.

STEP-1.
You have to download ODBC for window (If your server is Window) and download the version as your server was support, for more information you can see here "Download ODBC Driver" Oh! and please install in computer that you want to connect to an other server. (You have to register on site for free download)

STEP-2

After you have completed installed ODBC driver on your server then go to "Data Sources (ODBC 32-bit)"

STEP-3

Click on "System DSN" tab, you will see the popup (If you do not see that mean, you did wrong! ^_^ XOXO) Select the ODBC version as you have installed (For me I choose ODBC version 3.51)

STEP-4
Then you will see the popup window for you to fill information for connecting, then please fill all data as requested
- Data Source Name (put the name you as your idea but this job it quite hard for programmer to thinking the name and me too ^_^)
- Put IP address for server you want to connect to or if you want to connect localhost, just put this name in to TCP/Server
- Port, 3306 it was the default, you can change to an other port as your database server configuration
- User, It's your database username
- Password, It's your database password
- Click on "Test" if you fill all done to make sure for connection
- Oh! and one more thing, this is very important for me ^_^ because I am in Thailand and we use Thai language, do not forget to set Character Set by click at "Details>>" 


STEP-5
Character Set up, Click on Details then you will see many tabs appears, Do not hesitated to put character code as your requested for me I choose "tis620", WHY!? because if I forget and after I transfer data from MySql to SQL, I can not read Thai text, It will be an alien language ^_^ then PLEASE DO NOT MISS and if you have already set to tis620 it still not work, you have to config your window language in this step here

Read More

Business Intelligence

Business Intelligence (BI) What is it? Let's me tell you about my way as I know and understand.

BI it's just the concept to collection all data as you have on hand (some data it's in excel format, database in any platform, some are juck data) then we need to collect all data to clean, move, transfer, adapt or any verbs as you need to do to make your all data are quality for serve to your manager or CEO or any concern person as them requested. You can see my image (I have tried to drawing ^_^ look pretty!?)

And we have many tools to create the cube or report for CEO such as targit (In my experience said, YES! easy to create the report but toooooooo slow if you have big data more then 100,000 records to selection)

Any one else? Yes SQL server they have solution but you need to install Analysis Services Database, you have to selected all package in the first time when you have to install server (Click all if your server no have limited for recourse ^_^)
This is very simple to create a report, do not need more creative for design a wonderful report, but if your CEO or manage would like to add some photo, graphic, or color full, I'm not sure that this tool will be your best answer but for quality, I am guarantee.

And an other one as I know now it's IBM, it's name Cognos TM1 Performance, I have seen that the complicated things is, You can not query data and check it very easy as you use database, TM1 keep all data like a point of cube, That the weak point of TM1, You have to find an other technique to check data, For this detail I am still not sure google can help you ^_^ , Happy and Enjoin

If you have any idea and would like to share please send mail to me here aiauncha@gmail.com
Thank you for sharing

Read More