.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

Issue with the buffer size of DFT!!

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

Hi Team,

I have a question on defining buffer size in ssis dataflow task

Existing table with 207 rows size is 520KB. I have to load 10000 rows at the max, can I increase buffer size of the DFT to 26MB my server Ram is 2GB and I am running this on SQL Server 2000 database?



View Complete Post

More Related Resource Links

Accordion size issue

Hi I am using AJAX Accordion as side menu that i fill at the run time from database i create the panes and the menu items all at run time the problem here is that i cant make the accordion match the height of the page. i change the AutoSize to "Fill" and to "Limit" but still does not work as wanted it just fill based on the first opened pane so if first opened pane has 2 items then the accordion will take the height of the initial status as the accordion status any idea how to do that?   This is the script    <cc1:Accordion ID="SideMenuAccordion" runat="server" SelectedIndex="0" HeaderCssClass="accordionHeader" HeaderSelectedCssClass="accordionHeaderSelected" ContentCssClass="accordionContent" FadeTransitions="false" FramesPerSecond="40" TransitionDuration="250" Height="100%" RequireOpenedPane="true" SuppressHeaderPostbacks="true" AutoSize="Fill"> <Panes> </Panes> </cc1:Accordion>

Windows.Forms.Label size change issue



In a Windows Forms application developed with VB2008 Express, Label controls change size the first time the .Text property is updated.


On a Windows XP Pro SP3 system where the app was developed the labels retain the size set at design time.  On other systems, one also Windows XP, one Windows 7, labels shrink (all to the same size independent of content) the first time their .Text property is updated.  Labels that do not have their .Text property updated retain their design size.

Additional information:

The labels all occur within a FixedPanel of a SplitContainer.
Salient properties for the Label controls:
Anchor: Top, Left
AutoSize: False
BorderStyle: FixedSingle
Dock: None
Enabled: True
FlatStyle: Standard
Image: None
Locked: False
Margin: 0,0,0,0

WPF Application Size Issue

I'm planning to work on a desktop application using WPF. My biggest concern is, how to distribute this application to my users. It seems size of the framework 3.5 is near 200 MB. My users are not expected to download and deploy this much size from internet. Please suggest any alternative for this problem.

SSIS 2005 Buffer Manager Issue


Hi All,

I am facing Buffer Error while running my SSIS Package. I have configured BufferTempStoragePath Property of Data Flow task. Even though I am getting the following Buffer Manager Error.

Description: The buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property. There is an incorrect file name or no permission.  End Error  Error: 2010-09-24 07:40:01.01     Code: 0xC0047048     Source: DFT Load Fact Data DTS.Pipeline     Description: The buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property

Is there any other property settings or workaround to resolve the issue?



ISSUE: Cannot create a row of size which is greater than max 8060...Need Help




I have an issue related to maximum row size. I have a DW environment which has a table with multiple hierarchies and levels.


OLE DB error: OLE DB or ODBC error: Cannot create a row of size XXXX
which is greater than the allowable maximum of 8060. Errors in the OLAP
storage engine: An error occurred while the dimension, with the ID
of 'DATABASE', Name of 'DIMENSION' was being processed.
Server: The operation has been cancelled.

My current version is SQL Server 9.00.3257 (SP2 + CU 8). I would like to check if there is any upgrade available to fix this limitation (SQL Server 2005 SP3 / SQL Server 2008 SP1)....

Any advice is much appreciated.

Thanks in Advance

Buffer Size error when retrieving Metadata - How to increase size?


I am trying to retrieve the MetaData from the WCF Service using the following method.

// Create a MetadataExchangeClient for retrieving metadata.
EndpointAddress mexAddress = new EndpointAddress( uri );
MetadataExchangeClient mexClient = new MetadataExchangeClient( mexAddress );
// Retrieve the metadata for all endpoints using metadata exchange protocol (mex).
MetadataSet metadataSet = mexClient.GetMetadata();

How do I increase the buffer size?


Issue with Size Property has an invalid size of 0


In my code I have:

SqlParameter param = new SqlParameter("ID", id);
                param.Direction = ParameterDirection.InputOutput;
                wrapper.ParameterCollection.Add("StudentObjectiveID", SqlDbType.Int).Value = objectiveid;
                wrapper.ParameterCollection.Add("SessionID", SqlDbType.Int).Value = sessionid;
                wrapper.ParameterCollection.Add("StaffID", SqlDbType.Int).Value = staffid;
                wrapper.ParameterCollection.Add("EnteredDate", SqlDbType.DateTime).Value = entereddate;
                wrapper.ParameterCollection.Add("Achievement", SqlDbType.NText).Value = Achievement;
                wrapper.ParameterCollection.Add("SessionStudentID", SqlDbType.Int).Value = session_student_id;
                wrapper.ParameterCollection.Add("ImageName", SqlDbType.NVarChar, 255).Value = imagename;
                wrapper.ParameterCollection.Add("ActualDate", SqlDbType.DateTime).Value = actualdate;
                wrapper.ParameterCollection.Add("FileType", SqlDbType.VarChar, 10).Value = filetype;

                int result = wrapper.ExecuteNonQuery();
                id = (int)param.Value;

And in the relevant stored procedure I

How to go around the file size issue when uploading large files?



In my application the user uploads three files ( Resume, Cover Letter, Selection Creteria).

I want users not to upload more then 4 MB files, so In my web.confing file I have allowed max of 5 MB. <httpRuntime maxRequestLength="5000"/>. I did this so that I can validate the file and give user a message that they are trying to upload more then 4 MB file.

It all works fine if the user is only uploading resume. But if the user uploads all three files of size 4MB then my validation does not work and it goes to connection time out.

How can i handle the validation to check the file size of all 3 files?


Buffer issue on one particular column in an SSIS package

I have an SSIS package with a) Sharepoint List Source, b) Data Conversion, c) OLE DB destination.  

I had to use the data conversion component in order to change the string data from Unicode.

All fields come over fine except for a column that basically contains some HTML code.  It comes in as a 4000 character field, and I get this error even if I truncate the data in the conversion component.  

Here's the error:  

[SharePoint List Source [1]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.    at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value)    at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket)

Here's what the data in field looks like:

<div class=ExternalClass27637224667E4692AA7B7B0B2059FBE0><div id="_Note_9023a1eb-e648-4fac-aaa6-b7b5e38a628f" class="mmt_noteItem"><div class=

Block size issue



I am not sure where exactly to post my issue, so i thoguht the general area would work for now.  Please let me know if I should post this somewhere else....here goes:

I have a SQL 2008 cluster on Windpows 2008 R2.  I had a new admin add the SAN drives and they were never configured for 64K block size as recommended.  Once the cluster was built, the SQL install was completed and installed to one of the SAN drives.  now we have to reformat all of the drives and make them 62k block size.

Is it possible to cut and paste the SQL directories to another drive, format said drive, then cut and paste the directories back?

if not...

Is there a recommended procedure or tool available?


Do i have to just move forward with a complete uninstall/reinstall of SQL server?






Get Same Buffer Size in Socket Programming


Dear All,

Actually i am developing an app which send audio file from client to server and server read the byte and save that file in waver format problem is that  i want to send buffer size of audio file or audio length to server but didint get the same size so plz help me regarding this prob

i am using c#

how to increase UDP incoming buffer size


I need to increase the Windows UDP incoming buffer size for WINDOWS XP 64-bit, and also fine-tune Windows for optimum UDP performance.

software developer

Reduce ASP.NET Page size and complexity using JQuery

This is my first post on asp.net blog. ASP.NET Ajax and JQuery are two different ajax framework. In this post I will show, how we can enhance gridview using ASP.NET Ajax and JQuery. I also compare the implementation of these frameworks. In next posts i will explain more about JQuery and ASP.NET Ajax and also tell you "How to combine the power of both framework". My Future post will related to ASP.NET and related frameworks.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Set Custom Paper size in C#.net 3.5


Dear All,

I have to set custom paper size 6X8 inches

plz tell sugest me code how to do it.

in C#.net 3.5

i m using Asp.net 3.5 Crystal report

i have to do it programiticlly



MVC2 issue - Stuck. Trying to create a cms with nested partials


I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on. 

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

xpath issue


Hi i am using xpath to loop through each node,

the xml is below i can get the value of "link" but i cant get the thumbnail value, have you got any ideas how i can do this, my code is below.



     <link>test 1</link>
     <media:thumbnail url="http://test.com/image.jpg" height="75" width="75" />



     <link>test 2</link>
     <media:thumbnail url="http://test.com/image.jpg" height="75" width="75" />


public void FindLinks(XPathNavigator p_xPathNav, DataTable dt)
            //run the XPath query
            XPathNodeIterator xPathIt = p_xPathNav.Select("//item");

            //use the

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