Software Applications Programming Errors and solutions.

Issue: I want to check out this error that didn't show me while using the SQL Server 2008 version and its sql server business intelligence studio to create packages. Currently in the company we have migrated to SQL Server 2017, but when trying to execute a package with the SQL Agent (jobs) I get this mistake. Thing that never happened before. Suggestions: 1.This problem is of incompatibility with packages version before. 2.having a different bit version of windows and sql server or SSIS (64/32) can present issues. Reinstall/upgrade to 64 if possible.

Issue : This error come  before when migrate data from oracle to SQL server using SSIS ? Error Column "Col1" cannot convert between unicode and non-unicode string data types Solution: The column is coming back as unicode and then either being loaded into a non-unicode (varchar) column in the table, or possibly set to output as non-unicode in the oracle source (or non-unicode to unicode). Try putting a data conversion component in the data flow between the source and destination, and set data_1 column to match the type and width of the target table/column.

Application Domain Application domain is nothing but a process(not exactly as normal process) where the application will be running on it. Application domain will isolates all the applications by running each application in a diff. app domain. For instance, if 5 applications are running on your system, it will then creates 5 diff app domain to guarantee the security. It also has the following advantages, 1. An application can be independently stopped. 2. An application cannot directly access code or resources in another application. 3. A fault in an application cannot affect other applications. Definition of SQL Server Integration Service(SSIS). SQL Server Integration Services (SSIS) is one of the main issues of Microsoft BI (Business Intelligence) concept representing the data integration and data transformation in the enterprise level approach. SSIS (SQL Server Integration Services) has the ability to gather data from various resources in different kinds of formats, p