This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Hi All - I have an excel Macro sheet which is a source for me. I created an SSIS package and loads the data from excel to SQL Database table. The data is loading fine but for One column 'Column1#' it has values like below:
When loading the data for this column1#, the values for FCST is showing up as NULL in SQL table.
In SQL Table, this column is varchar(255) NULL and also i tried with nvarchar(255) NULL as well.
In SQL table its loading as below:
What steps should i take to flow the data as is without missing any data from this column.
Thank you in advance.
Hi @kkran
I could not re-produce the issue, it seems to be related with the setting of your excel.
Add Data Conversion or Derived Column to convert the column1 to [DT_WSTR] or [DT_STR], and then load the data to sql table to see if it is helpful.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
I have converted to DT_STR using the data conversion and also i enabled the data viewer and i was able to visually see its showing up as NULL.
So, i opened up the excel and just pasted the string value in SQL. This is how it is. the end single quote is going to next tab or line. Should i use any replace function or anything ? May be its not reading some unprintable characters ?
Hi @kkran,
Use Derived Column to remove the quote and then preview the data for a try.
REPLACE(column,"'","")
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Thank i tried the options but this didn't resolve.
But however, i had to change the column format in EXCEL to Text, which resolved the issue.