.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Converting DataType=TEXT to DataType=STR

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hi,I have an input text file which contains line(s) which can have more than 8000 characters. I am able to read the lines in this file by specifying that the input column is data type = Text Stream [DT_TEXT] and I can then write the lines to another text file.But, what I want to do is to use only the right-most 8000 characters. When I try to convert the input column to data type = String [DT_STR] using the Data Conversion transformation then I get the error:- The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.I cannot use the string manipulation functions e.g. RIGHT or SUBSTRING in a Derived Column transformation because these functions do not work with DT_TEXT data. Any Ideas?!Thanks.

View Complete Post

More Related Resource Links

What is CultureInfo datatype?


Hi all members!

        whats  Cultureinfo datatype.Please help to know clearly..I ve seen more Sites but i can't able to understand guys!!

        Ex:("CultureInfo culture = new CultureInfo( "hi-IN" );")Embarassed

Store Null Data In image datatype in sql server 2005



i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.


Query on XML datatype in SQL Server 2008

Hi All, In table I have column with XML datatype. I can able to read the below XML tag. SET   @Title = CAST(@XMLContent.query('data(root/chemicalName)') AS VARCHAR(50)) <root><chemicalName>Sulphuric acid</chemicalName></root> but how can I read (in SQL Server 2008) with multiple rows in it, and how to know the list of child nodes and data of it dynamically? <Root> <Row> < CurrencyCode>GBP</CurrencyCode> < CurrencyName>POUND (STERLING)</CurrencyName> </ Row> <Row> < CurrencyCode>INR</CurrencyCode> < CurrencyName>Rupee</CurrencyName> </ Row></

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Insert/Update OLE Attachment(Binary datatype) using SQL server 2000

Hi All, In the same senario how we can Insert/Update OLE Attachment(Binary datatype)  from one source table to other destination table by using SQL Server 2000 not with C# fronend code. Appreciated if you can give fix on this regads, Divakar.

Converting Hindi Text to English Text

Hi,Can someone guide me in converting hindi text to english text using c#.  The application will be windows based.  When I googled it says it will be possible using google/translate.  However I am not aware of how to use that in my application.Any ideas?Regards,Karthizen

How to sorting different datatype in CollectionView?

I have a treeview using HierarchicalDataTemplate with itemssource collectionview that includes A_collection and B_Collection it looks like: Root -  A   --  B   --  B   --  B -  A   --  B   --  B -  B -  B -  B I tried to sort the whole tree by B.Time property.  How can I only sort B.Time in collectionView which has A and B collections and keep A in previous order? Please advise, thanks.

Using equal operator in transact-SQL for ntext datatype column

Hi, I've a problem with using equal operator in transact-SQL for ntext datatype column. (SQL Server 2000) I'm using the following SQL command text. use NorthwindSelect * from Categorieswhere Description ='Seaweed and fish' If I use 'like' operator intead of '=' then the qurey retuns correct value. Any idea about this? Any help is appreciated. Regards, Julia

retrun dataType of filtered data using REST API ?

I know how to get filter data but unable to figure out return type Here is my Code if you can please correct me       ClientsItem item = (ServiceReference1.ClientsItem) client;     string cl = item.Title;     string url = @"http://sharepoint04/sites/Test/_vti_bin/listdata.svc/Projects$filter=Client eq ' " + cl + @"'" ; ServiceReference1.   TestDataContext cont = new ServiceReference1.TestDataContext(new Uri(url));

What can be the datatype for a column having records as weblinks?

Hi, i am trying to insert records in a column having records as weblinks but it gives me following error. --------------------- Msg 128, Level 15, State 1, Line 2 The name "www.yahoo.com" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. -------------------------------- NOTE : i have tried nvarchar(2083) but still giving me the same error. but if i try insert something like http://yahoo.com i get ERROR : incorrect syntax near 'http:'-   

The 'DataType' attribute is not declared bug of MS SQL RS still here

Greetings. I am getting repeated bugs with reporting services that is described here https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=405739&wa=wsignin1.0 In short words, BIDS is saving the report in the wrong format, adding attributes to the tags that dont belong to the schema, and you can no longer open the report with BIDS, you have to carve those attributes out with Notepad, only to find out that next time you're working on it, they come back! This is getting seriously annoying as i virually cannot close my BIDS anymore, each time i want to reopen my project i have to edit it in the notepad!  Threre are words about "microsoft knows about this issue and changed it to "Fixed (External)" but noone knows how to install the fix... Help please.

how to get datatype a column in sqlserver ?

hi all I want have datatype a field in sqlserver how to get it with (T-sql) thank you

filestream datatype

What is the difference between :enable filestream for  t-sql statement and  enable filestream for file i/o streaming access in sql 2008 when and how both feature works?

hierarchyid datatype in sql 2008

hi everyone, I wanted to know what exactly GetDescendent(null,null)method represent.what 2 parameters(null,null)takes it. How it works? Thank you

oracle clob datatype length more 32000

Hi Friends       i am using a microsoft enterprise library for oracle data base. we return an output value of clob datatype in oracle of character length more thant  32000.How to handle this type problems in C#.net.if the passing a varible of string ,it chara cter limit is 32000.if than 32000 ,how to handle this in enterprise library.  

Inserting an 'image' (datatype) value through SQl and C++

In the application I develop, the database table having a column of 'image' datatype. Now I want to insert the values into that table directly from my program, which is in VC++ 6.0, using a direct ExecuteQuery() of INSERT(due to performance considerations).

C# Datatype Issue

I have a C# app that is passing in a system.array variable by reference to an external DLL.  When I look at the data type of the returned variable by calling .GetType().FullName, is shows as System.Int32[*].   What does this data type mean??  I have searched high and wide and cannot find any documentation on this datatype.   I initially thought it was an array of integer pointers but when I tested this it came back as System.Int32*[].   Please help me understand what the System.Int32[*] datatype is.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend