November 2, 2012 at 1:05 pm
hi
i would like to store values like mg/1,
mg/15ml
etc.
will nvarchar(50) will work,when i am using ssis package ,its gives me error
November 2, 2012 at 1:45 pm
harri.reddy (11/2/2012)
hii would like to store values like mg/1,
mg/15ml
etc.
will nvarchar(50) will work,when i am using ssis package ,its gives me error
What error? Remember we can't see your screen, read your mind, or have any knowledge of your project.
varchar(50) would be perfectly fine for the data you presented. There are no unicode characters in there.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 5, 2012 at 12:46 am
harri.reddy (11/2/2012)
when i am using ssis package ,its gives me error
Paste the error here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply