Exploring

Wednesday, December 24, 2014

Import Excel unicode data with SQL Server Integration Services



Import Excel unicode data with SQL Server Integration Services


Cannot convert between a unicode and a non-unicode string data types


Import Excel unicode data with SQL Server Integration Services




Posted by Daily Learning at 8:21 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2019 (11)
    • ►  February (1)
    • ►  January (10)
  • ►  2018 (25)
    • ►  November (1)
    • ►  February (11)
    • ►  January (13)
  • ►  2017 (6)
    • ►  November (3)
    • ►  February (3)
  • ►  2016 (41)
    • ►  December (1)
    • ►  November (7)
    • ►  October (3)
    • ►  August (3)
    • ►  July (2)
    • ►  June (6)
    • ►  May (8)
    • ►  April (4)
    • ►  March (1)
    • ►  February (3)
    • ►  January (3)
  • ►  2015 (61)
    • ►  September (1)
    • ►  July (6)
    • ►  June (2)
    • ►  April (2)
    • ►  March (13)
    • ►  February (33)
    • ►  January (4)
  • ▼  2014 (99)
    • ▼  December (82)
      • SSIS - Invoking / Running / Controlling one SSIS p...
      • Interactive SSIS package
      • SSIS - Performance Tuning Tips and Tricks
      • SSIS - Best Practices I SSIS Tutorial I MSBI
      • Informatica vs. SSIS
      • SSIS - Incremental Data Load
      • SSIS - Encrypt
      • SSIS - Debugging
      • SSIS - Passing values from Parent to Child package
      • SSIS- Pivot Transformation in SSIS (Part 1 of 4)
      • SSIS - What s New in SSIS 2012 and 2014
      • SSIS - FTP Task File System
      • SSIS - DTUtil command prompt utility
      • SSIS - DTExec command line
      • SSIS - Ping Directory To check for file's arrival
      • SSIS- Zip Files
      • SSIS - Copy Column Transformation
      • SSIS - Tuning packages so they run faster.
      • SSIS - Using Containers
      • SSIS - Expression and Other Constraints
      • SSIS - RowCount Transformation
      • SSIS -Store Images,Documents,PDF (BLOB) Files Into...
      • SSIS -Audit Transform
      • SSIS - Pivot and UnPivotTransfromations
      • SSIS - Advanced Precedence Constraints
      • SSIS - Using Temp Tables
      • SSIS - Generate XML Formatted File
      • SSIS - Checkpoints
      • SSIS - Load XML Files
      • SSIS Incremental Load - Data Hashing
      • SSIS - Parallel Data
      • SSIS - ForEach ADO Enumerator -Flat Files Dynamically
      • SSIS - Load Data from Multiple Source (Text & Excel)
      • Isolation Levels In SQL Server
      • Configure Database Mail, Operator and Notification...
      • SSIS - Variables And Expression
      • SSIS - Multicast transformation
      • SSIS - Merge Join transformation
      • SSIS - Aggregate & Data Conversion Transformation
      • SSIS - Using a Union All & Merge transformations
      • SQL Server 2008 - Import-Export Wizard
      • MSSQL - How to configure SQL Proxy and Credentials
      • Can SQL Server views be updated
      • collation conflict
      • Data Dictionary
      • SQL QUERY replace NULL value in a row with a value...
      • Excel to SQL Server -Bulk Insert
      • Import Excel unicode data with SQL Server Integrat...
      • Returning a result set with multiple rows based on...
      • Transform rows into columns in sql server
      • Loop through Flat Files in SQL Server Integration ...
      • Scheduling SSIS packages to run using SQL Server A...
      • SQL INSERT INTO SELECT Statement -Update
      • TRY..CATCH block - RAISERROR - THROW statement
      • What is the difference between SQL, PL-SQL and T-SQL?
      • SQL - String Functions
      • SQL Server query execution plans – Viewing the plans
      • Create a Transact-SQL Job Step
      • SQL SERVER – Understanding Table Hints
      • SQL SERVER – Difference between Temp table,Table v...
      • QueryAnalyzer VS. Query Profiler
      • Transaction:IMPLICIT - Explicit Transactions
      • How to capture the performance monitor counters an...
      • Query Execution Plan
      • Finding blocking/locking queries
      • SSIS - Fuzzy Look up Transformation
      • SSIS - Lookup Transformation
      • Scheduling SSIS packages to run using SQL Server A...
      • SSIS - Precedence Constraints
      • SSIS - Passing Parameters SQL Task - Variables A...
      • Event Handlers And Custom Logging - SSIS
      • How to load an XML file into a database using an S...
      • SSISDB Catlog
      • SQL Server Integration Services (SSIS) Tutorial
      • Parallel Execution in SSIS with MaxConcurrentExecu...
      • SSIS File System Task
      • Slowly Changing Dimensions (SCD) SSIS
      • DTSxchange for DTS to SSIS conversion
      • Trigger - a record Update
      • Cursor
      • Stored Procedure
      • What is covering index?
    • ►  November (5)
    • ►  March (5)
    • ►  February (7)
  • ►  2013 (39)
    • ►  December (1)
    • ►  November (4)
    • ►  October (9)
    • ►  September (8)
    • ►  August (3)
    • ►  July (13)
    • ►  March (1)
  • ►  2012 (2)
    • ►  November (2)

About Me

Daily Learning
View my complete profile
Picture Window theme. Powered by Blogger.