Hi i am trying to export data from .csv file to sql server and my data is coming as
"xyz" where i want only to store as XYZ i am using derived column but i am not able to capture " and replace it what approach should i take here , also i am trying to convert String True to Boolean 1 and vice versa for False in database how do i do that please help me with this.
Look at the REPLACE function. Also, aren't you specifying (") as the text qualifier in your file setup
As for converting the string True/False to boolean, you can use conditionals in a derived column. [Column] = "True" 1 : 0
You might just be able to cast the column, though I'm not sure. You'll have to test that out.
I am trying to store the value of True or False in a bit field in sql server which will be 1 for true and 0 false .. i am confused as to whether i need to cast it before storing it . please guide me.
From the Data Viewer i can see the Values changing to 1 and 0 but how do i store them as bit datatype in sql server
Dev2624 wrote:
I am trying to store the value of True or False in a bit field in sql server which will be 1 for true and 0 false .. i am confused as to whether i need to cast it before storing it . please guide me.
From the Data Viewer i can see the Values changing to 1 and 0 but how do i store them as bit datatype in sql server
I tried and it is storing as True in the column value but not as 1 in sql server , i am not aware of how exactly bit datatype works