Are you getting an error during SQL Server 2012 setup referring to a hexidecimal value 0x00 is an invalid character? It appears this error comes from the pre-existence of the MSDE installed on the same system. The screen shot below shows the error on a machine where MSDE is installed and SQL Server 2012 Express Edition is attempting to be installed. The solution was to simply remove the MSDE (Microsoft SQL Desktop Engine) prior to installing SQL Server 2012.
Remove MSDE to Allow Installation of SQL Server 2012
Simply uninstalling the MSDE through Control Panel solved this issue.
The first thing you need to do once you have a Talend Project created is define your connections that data will be extracted from or where it will be written to.
Microsoft SQL Server is a good example of a database that many users will need to work with in ETL, so we will cover how to add that to your project in Talend.
1. Create the Connection in Talend Repository
In your open project, look for the Repository. This is where you will find many different objects available within your Talend project. Specifically for adding a connection, we are going to expand the Metadata category within the repository. Then you will need to right-click on “Db Connections” and choose “Create Connection”
2. Enter MS SQL Connection Name
You will then be prompted with a dialog box that will walk you through creating your connection. In the first box which is step 1/2, enter at least a name for your connection and then click Next.
3. Enter MS SQL Connection Details
Next, enter the details needed to define your connection. Make sure to use SQL server authetication by entering a Login and Password. Currently, Windows Authentication with SQL Server 2008 is not consistent. After you have entered the details click “Finish”
You will now see your connection under Metadata in the Talend Repository