meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 2 months |
| seen | yesterday | |
| stats | profile views | 5 |
|
May 8 |
accepted | Converting Non Unicode string to Unicode string SSIS |
|
May 6 |
comment |
Converting Non Unicode string to Unicode string SSIS Awesome. Thanks. Definitely a time saver! |
|
May 6 |
asked | Converting Non Unicode string to Unicode string SSIS |
|
May 6 |
revised |
SSIS keeps force changing excel source string to float added 291 characters in body |
|
May 6 |
revised |
SSIS keeps force changing excel source string to float edited body |
|
May 2 |
accepted | SSIS Expressions Date Format get just YY for year |
|
May 2 |
revised |
SSIS keeps force changing excel source string to float deleted 1 characters in body |
|
Apr 25 |
awarded | Popular Question |
|
Apr 18 |
comment |
Update “NULL” string to Actual NULL value that worked perfectly! thanks! |
|
Apr 18 |
accepted | Update “NULL” string to Actual NULL value |
|
Apr 18 |
comment |
Update “NULL” string to Actual NULL value more like 30 to 40 columns |
|
Apr 18 |
asked | Update “NULL” string to Actual NULL value |
|
Apr 17 |
revised |
SSIS keeps force changing excel source string to float added 132 characters in body |
|
Apr 16 |
revised |
SSIS keeps force changing excel source string to float added 98 characters in body |
|
Apr 11 |
comment |
SSIS keeps force changing excel source string to float I'm hopping the change to .csv or txt file is in the near future. will make things much easier. |
|
Apr 5 |
accepted | SSIS Data Flow Task Excel to SQL table NULL value will not work for small INT datatype |
|
Apr 5 |
comment |
SSIS keeps force changing excel source string to float @billinkc VB skills are good. But no C# experience. |
|
Apr 4 |
comment |
SSIS keeps force changing excel source string to float Yes that will work but I have close to 50 excel files that I need to import and going into every excel to change the problem column to Text would take a long time. I could create a VBA macro but the problem is We will continue recieving these files with the same format... and I would like to do all the work in SSIS if possible |
|
Apr 4 |
comment |
SSIS keeps force changing excel source string to float @Zane Thank you for your help. You were absolutely right about changing the datatype of the destination table column to accept numeric values. I changed the data type to float and it worked. Unfortunately I am importing a large number of files and I just realized that I will be needing to use NVCHAR because I have Diagnostic Codes such as V3.24 and V324.1 which I was not aware about. |
|
Apr 4 |
comment |
SSIS keeps force changing excel source string to float I see your point now. I am going to change the datatype in sql table to numeric and see how it goes. Thanks for your help. I will post back briefly with results. |
