.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

How to create Named Set in BIDS 2005

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

How can I create a named SET that generates the table, below? I am using BIDS 2005 and Excel 2007






California             1000                       200          &

View Complete Post

More Related Resource Links

Visual Studio 2005: Create Reusable Project And Item Templates For Your Development Team


Visual Studio 2005 introduces a new model that lets you define your own project templates and starter kits, something developers have been requesting for some time. Here Matt Milner shows you how to consume, create, and customize these templates.

Matt Milner

MSDN Magazine January 2006

can not able to create a new web project as http:\\localhost\project name in .net visual studio 2005

can not able to create a new web project as http:\\localhost\project name in .net visual studio 2005

sql server 2005 express - don't allow to create table

i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

How to Create Named Set on the fly?

Hi, I was just wondering if anyone could help on this. What I want is, for some objects like Named Set e.g., they are only applied to the cube when needed. In other words, I don't want to define them on an instance, nor I want to define them in each query. I want them to be built on demand, say by a SQL job. Is that possible? Thanks,  

create a sql server 2005 new login for SQL Injection prevention

    Hi All,  Thank you for advance. Our database affected with SQL Injection. so We need to create a sql server 2005 new login for SQL Injection prevention User can perform, access tables with select,update and delete queryaccess views, functions and stored procperform cursor     what are the permissions given for that login account?

how to create XML Schema Collection for SQL 2005

I am generating below schema at run time in C#, Is there any way to create a XML Schema in SQL 2005 for this run time generated schema??? <?xml version="1.0" encoding="utf-16"?> <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="Address"> <xs:complexType> <xs:sequence> <xs:element name="Name" type="xs:string" /> </xs:sequence> </xs:complexType> </xs:element> </xs:schema>

SSIS 2005 Logging different events under BIDS and Scheduler

I have a package that is working and logging correctly under BIDS 2005 (SS 2005). It logs what I want (in particular "Information" log messages) to a text file. But when I run the package under the scheduler, all it logs to the text file is "Package Started" and "Package Ended". How do I get it to log the same messages under the scheduler as under BIDS?

BIDS 2005 cannot find Stored Procedure

I have read how to do this in multiple places but my report is not able to use a stored procedure for retrieving data. When I select command type 'stored procedure' to populate my dataset, and then switch to the GUI query designer, I only see a partial list of system SPs, not my user defined SPs. My SP does return a single dataset.If I try to manually use the SP, with or without doublequotes and EXEC, the report designer simply tells me that the SP cannot be found.

Create DLL from C code using Visual Studio 2005

I have a commercial application (ZEMAX) that uses DLLs to describe problem geometry.  They provided source code in C for one of their DLLs.  I would like to modify that source code and generate a modified DLL.  Can I do that with Visual Studio 2005 (how?) or do I need a different IDE?

Cannot create a connection to data source !!!! SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group!  Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.  I thought that since this datasource was set to Windows Authentification that it would just pass it through? I'm pulling my hair out at this point: Screen Shots: http://www.webfound.net/datasource_connection.jpg http://www.webfound.net/datasource_connection2.jpg http://www.webfound.net/datasource_connection3.jpg Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run An error has occurred during report processing. Cannot create a connection to data source 'datasourcename'. For more information about this error navigate to the report server on the local server machine, or enable remote errors

DTExec is MUCH slower that just running my package in Debug mode in BIDS 2005

I am using BIDS / SSIS 2005.  I have a large package that runs very smoothly and fairly quickly when run in debug-mode through BIDS.  When I actually deploy the package to SSIS and execute it using either DTExec or DTExecUI it is WAAAAYYY slower than when run from the development environment.  So slow that I become convinced it is hanging on steps that execute very very quickly in BIDS.  I have read this thread -> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5585fa13-dd15-4406-9d4a-e993f2af5929 which has not helped. I understand that DTExec would be faster than DTExecUI because the former does not have to deal with the GUI component but I would have expected both (and especially DTExec) to be faster than running in debug from BIDS. I realize I am not providing a ton of detail here, problem is I just don't know where to start... any advice on what I should be looking at to improve package execution through DTExec and / or DTExecUI would be greatly appreciated.  Why would DTExec be so much slower than BIDS Debug??? Thanks in advance.. - Charles

SSIS 2005 & 2008 BIDS and VS2005/2008 Will VS2010 work with either SSIS package?

I've read the old posts about having to have the BIDS version match the SSIS package version. My question is with VS2010 is there any change? Can I edit either of the old versions of SSIS packages in VS2010 or do I have to have 3 versions of Visual Studio/BIDS on my machine? TIA J

What is the latest version of Business Intelligence Development Studio (BIDS) 2005

When open BIDS 2005 and go to help ---> about i see the following: Microsoft Visual Studio 2005 Version 8.0.50727.42  (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 SP2 Do I have the latest service pack installed for BIDS?

How to create a Table of content in .rdl design in BIDS.



well am having a problem on.

How to create a Table of content in .rdl design in BIDS. either it should be dynamic or there should be bookmark of each section in TOC.

can any one help me out.?..



Create and Deploy Charts using SQL Server Business Intelligence Development Studio 2005


Hi All,

Does any one have good blogs for creating different types of charts using SQL Server Business Intelligence Development Studio 2005 which pulls data from the sharepoint list and display in graphical format. iam new to SSRS.

Thanks in advance

How to create a Table of content in .rdl design in BIDS dynamically according to the Page no wise..?



well i am able to create the TOC statically by using the Document Map properties as describe in my older post issue 

but now i just want to create the Table of contents dynamically generate using the page no wise..is it possible...how can we do it while designing the .rdl in BIDS..



SSIS 2005 - Dynamically generate create table statement from source



I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.

Please suggest



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