.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

Steps by steps to load data

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
Hi Experts, Can anyone list the steps for loading a dimension data from a sql database in  ssis to a dimension in ssas? Thanks in advance!

View Complete Post

More Related Resource Links

steps for loading data into a dimension table


Hi Experts,

Can anyone give me the steps for loading data into a dimension table from a SQL database table? An explanation as to why the objects are used will be very helpful.

Thanks in advance

A better way to reference your wizard steps using named steps

Note: this article uses the plain vanilla but the concepts apply equally well to its popular counterpart .

By far the most common way that I see wizard steps reference in code snippets is by their index.

huge number of data from database ... so how to minimize load time


Hi ...

I have used the above method to configure my crystal report ...

Its working fine , But i have huge number of data in database ....

So , it take long time to load the report ...

So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.

Plz help me with this issue  ...


Also , Plz explain me abt index legend in crystal report.

Utility Spotlight: 12 Steps To Faster Web Pages With Visual Round Trip Analyzer


Download Visual Round-trip Analyzer (VRTA) to uncover the root of your Web page loading problems and identify these 12 common ailments.

Jim Pierson

MSDN Magazine November 2008

Data: More Load, Less Code with the Data Enhancements of ASP.NET 2.0


A data source control is a server control that wraps some basic functions of a data source - be it a SQL Server database, an XML document, an Excel worksheet, or a sitemap description. Through the services of a similar component, data-bound controls can fetch data as well as insert new records or update and delete existing ones. Data source controls enable a consistent model across a variety of data sources and dramatically reduce the amount of code needed to implement a two-way data-binding scenario. This article provides an introduction to data source controls and other related data binding features.

Dino Esposito

MSDN Magazine June 2004

Ajax Accordion to load data from client click event


I have a Ajax Accordion control on my page with treeview in Content Template. As the treeview for each pane are big. I am wondering whether I can load the treeview from codebehind only after the pane is selected. I can reuse the code from ItemDataBound of Accordion control.

Can I create several steps to be run on a SharePoint list as a task to run on a daily basis?


We have a manual process that we do on a SharePoint list to export data from SharePoint to a spreadsheet that can then be used by non SharePoint programs.  I'd like to be able to automate this process so that it can be scheduled as a Task to run on a daily basis.   Not sure if a workflow can do what I'd like it to.  I have SharePoint Designer 2007 as well.

Here are the steps:

1. Load a particular View of a SharePoint List

2. From the view's Action menu, "Open with Access"

3. Save the resulting Access database as a file to a specific Folder on the computer hosting SharePoint

This would be run as a Task on the computer hosting SharePoint.

System.Data.SqlClient.SqlException: Bulk load data was expected but not sent

Hi everyone We've had this error twice now from our C# code. Nothing is changing the columns, but I've noticed though that it appears to happen when two threads are attempting to bulk insert into the same table, generally millions of rows. The docs say that SqlBulkCopy.WriteToServer is not guaranteed to be thread-safe, but is this the problem here? It feels like it. I've seen some posts where people appeared to have experienced problems in similar circumstances (http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/85d51484-6381-46bc-bcce-63b58b362d2d). There is no identity column just a non-unique clustered index that is (spid) process keyed to each thread. Do I need to synchronise access to the table for WriteToServer - is this a known problem? Many thanks Reg --- System.Data.SqlClient. SqlException: Insert bulk failed due to a schema change of the target table.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()   at System.Data.SqlClient.SqlBulkCo

How to use OPENXML to load XML data into existing SQL Table?

I am a newbie to OPENXML. But I am trying to load a .XML file into a SQL table that I created for this. I do not receive any errors with this code, but it doesn't insert any records either. This is the table I created in 2008 SQL Server: CREATE TABLE HOMEROOM( HOMEROOM_TEACHER INT, HOMEROOM_NUMBER INT, ENTITY_ID INT) And this is the T-SQL code I am trying to execute: DECLARE @idoc int DECLARE @xmlDocument varchar(MAX) DECLARE @Status INT SET @xmlDocument =' <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> <s:Schema id="RowsetSchema"> <s:ElementType name="row" content="eltOnly"> <s:AttributeType name="c0" rs:name="HOMEROOM-TEACHER" rs:number="1" rs:nullable="true"> <s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" /> </s:AttributeType> <s:AttributeType name="c1" rs:name="HOMEROOM-NUMBER" rs:number="2"> <s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" rs:maybenull="false" /> </s:AttributeType> <s:Attri

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

How to execute a set of steps N time, in parallel?

I have a custom workflow activity that creates "tasks" for users to do.  Tasks are shown to a specified user when they log in to the web site.  When this step runs, it takes in a userId, creates a task in the database for that user, and then sets a bookmark.   When the user goes to the web site, they see their tasks.  When they push a button to complete a task, the bookmark is resumed and the step ends.   So far so good.  The problem is that the design now calls for the workflow to be able to kick off multiple tasks for multiple users, and that all the tasks be started at once (that is, its not good enough for user #1 to receive a task, complete it, user #2 receive a task, complete it, etc.  All the users should receive their task to start with, and then they can finish them in any order.)   I can't do this serial with a for loop, since then there'd only be one task "outstanding" at a time, and they'd have to be completed in order.  I can't simply modify the custom activity to take in the multiple pieces of data, because there's a lot of other items that happen in the workflow that need to be done before and after the custom activity for each task.  What I'd really like is something like the Parallel activity, where I create the branch and place all the tasks, but then I can assign the number of times

Could not load file or assembly "System.Data.DLL" or one of its dependencies

Could not load file or assembly "System.Data.DLL" or one of its dependencies

What are the Steps Installing Infopath Form Service on WSS 3.0 or do I need to upgrade to MOSS?

I  have configured Extranet Https Portal for our configuration.It includes some custom web-parts features in the site. My WSS 3.0 -Cenrtal Admin version is I have MOSS 2007 - Central Version Now I have designed a Infoapth form and want to publish to a library in the site.We can publish the form to a library but At client side Infopath 2007 sholud be installed in order to submit the form.It is not Browser Enabled. ( You cannot enable InfoPath Forms Services in WSS, because it is not present in WSS. Before you can enable InfoPath Forms Services, you have to install Forms Server or MOSS Enterprise.  It is not Browser enabled.  ) Infopath form services is a component of MOSS not WSS Is there any other way instead of intalling Moss 2007 can I only Install Infoapth Form services on it. Can I upgrade the WSS 3.0 to MOSS 2007 and get the Infoapth form services to the existing site without any loss of data.   I have read that while upgrading wss to moss the central admin version  should be same then only you can upgrade is this true?? what steps I need to consider ?? Guide me Thanks in Advance Harish

skiping the steps in SQL server job

Below is my requirement  :  STEP 1 : Run the procedure if today is not a holiday (i have table to check whether today is holiday or not)  STEP 2 : Call the scheduler task using Type : Operating System(cmdExec) c:\windows\system32\schtasks.exe ***** if today is not a holiday.(need to check whether today is holiday or not in a table) How do I do the second step : the point is i want to skip the second step if it is holiday.. I know we can play with onsuccess and Onfailure OR creating 2 job for each steps.. but that's not am looking for is there any other way we can do this?

What steps to enable My Sites to be accessed externaly when it uses port 9000 and not 80

Hi, Running Sharepoint 2010, Windows server 2008 R2, ISA server 2005. I have two web application running on different ports "Home" running on port 80 and "My Sites" running on port 9000. I have enabled the "Home" site (port 80) to be accessed through the ISA server so users can log in remotely and now have to do the same for the "My Sites" (running on port 9000) but am unsure of what steps i have to take since it is using a different port. Will I have problems with users accessing this from Hotels, cafes etc since this port isn't open or is all the traffic directed through port 80. Do I need to open this port on my firewall? Is this all taken care in Alternate access mapping? Any help would be appreciated.  

SSRS 2008 R2 Problem understanding View State Validation steps

Hi, Sorry, but I have some problem understanding this steps. Please help me to understand this.  Pasted from http://technet.microsoft.com/en-us/library/cc281307.aspx?lc=1033 How to Configure View State Validation To run a scale-out deployment on an NLB cluster, you must configure view state validation so that users can view interactive HTML reports. You must do this for the report server and for Report Manager. View state validation is controlled by the ASP.NET. By default, view state validation is enabled and uses the identity of the Web service to perform the validation. However, in an NLB cluster scenario, there are multiple service instances and web service identities that run on different computers. Because the service identity varies for each node, you cannot rely on a single process identity to perform the validation. To work around this issue, you can generate an arbitrary validation key to support view state validation, and then manually configure each report server node to use the same key. You can use any randomly generated hexadecimal sequence. The validation algorithm (such as SHA1) determines how long the hexadecimal sequence must be. Generate a validation key and decryption key by using the autogenerate functionality provided by the .NET Framework. (Well, how to generate Validation key using .Net Framework?) In the end, you must have a singl
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