tags:

views:

88

answers:

0
Q: 

SSIS ole db source stays on pre excute with data type unicode text stream

i am importing data from database SQL server 2008 to csv files .The source data has unicode format and the destination is non Unicode. As the source string can be very large i chose the the data type unicode text stream of the source column in stead WSTR in SSIS OLE DB source but due to this keeps on waiting on pre execute stage of Data flow task indefinitely
if i change the source column from Unicode text stream to WSTR it works fine Please help if any one has any idea of this weird behavior

related questions

C# Exception Handling continue on error
Exporting tab-delimited files in SSRS 2005
How can I join a list into a string (caveat)?
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
Looking for tool to generate random CSV data
csv api for java
in rails, how to return records as a csv file
Import *variable record length* CSV file using SSIS
asp.net Convert CSV string to string[]
What's the best way to extract table content from a group of HTML files?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
Program for working with large CSV Files
How do I best generate a CSV (comma-delimited text file) for download with ASP.NET?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
Java code to import CSV into Access
Parsing XML using unix terminal
CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?
Generate Insert SQL statements from a csv file
Split a string ignoring quoted sections
FileHelpers performance
CSV string handling
What is a good web-based Grid that accepts Excel clipboard data?
CSV File Imports in .Net
How to export data from SQL Server 2005 to MySQL
Converting CSV File to XML in Java