Business Inteligence Projects In VS 2008

Jan 22, 2008

Hi all,

I just installed Visual Studio 2008 in my machine and removed VS 2005 as I thought it wasnt needed anymore. However, my Business Inteligence studio for SQL Server stopped working now...I understand that I can reinstall VS 2005 to get everything back up and running, but whats the whole point of upgrading to a newer version if its not backward compatible?

So, is there anyway to create/open business intelligence projects in VS 2008?

Thanks

View 4 Replies


ADVERTISEMENT

Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation

Oct 23, 2007

Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?

I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.

Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.


Thank you

View 1 Replies View Related

Not Seeing Business Intelligence Projects

Dec 16, 2007



Hello everyone..

Start with a Vista Ultimate laptop running in x64. VS 2005 loaded second in x64 mode and sql 2005 developer loaded with everything in x64 mode.

I see the x64 service running in the sql server configuration manager but I don't see business intelligence project under sql server in the start menu or as a type in VS 2005.

Please help.. I love SSIS

View 5 Replies View Related

Visual Studio 2005 And Business Intelligence Projects - Dwproj Not Installed

Apr 21, 2007

When I start Visual Studio Business Intelligence studio I get dwproj is not installed



What to do I run visual Studio 2005

SQLServer 2005

View 1 Replies View Related

How Delete BIDS Recent Projects Projects?

Jul 24, 2006

When I open BIDS it displays a list of "Recent Projects". How can I edit (or delete) items from this list? (Over time the list has acquired a lot of junk est projects that I no longer need).

TIA,



Barkingdog





View 1 Replies View Related

Windows Vista Business 64 And Microsoft Visual Basic 2008 Express Edition Bad Sqlceme35.dll

Feb 11, 2008

I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:

An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.

Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.

The problem persists, any ideas, please?

View 6 Replies View Related

Business Intelligence Project/Integration Services Project Not Showing Up In Visual Studio 2008

Mar 31, 2008

I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.

Thanks.

View 7 Replies View Related

Sql Server 2005 (business Intelligence Development Suite ) Problem Installing Sql 2005 On Vista (vs 2008)

May 7, 2008

I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......

Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010

View 2 Replies View Related

Synchronization Of Business Contacts In Outlook With Small Business Accounting

Jun 10, 2006

Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?

I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.

Has anyone tried this?

Can someone walk me through the process?

Thanks

Debbie

View 1 Replies View Related

SQL Projects

Mar 17, 2007

I would like to spend as much time as I can working on SQL projects but my daytime job doesn't exactly call for it. My end goal is to be MS SQL DBA certified and hands on skills will help me get there.

Is there a website where I could offer my time and skills to work on SQL projects - DB design, scripting, development, admin, etc - I would offer my time and sklls for cheap or free in exchange for the experience.

Thanks,

-Allen

View 1 Replies View Related

Can't Add Database To Projects

Sep 12, 2006

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=497273&SiteID=1


I have gone through the above and, while I can connect to the sql server and activate connections, I can not add a sql database to a project.

Open a project
Right click - add new item
Choose sql database

or

Add existing item
choose existing sql database

results in:

"Connections to SQL server files (*.mdf) require sql server express 2005 to function properly blah blah blah"


Like I said, I can connect to the DB through the server explorer and view table definitions and data. I just can't add one to a solution. I have reinstalled sqlexpress already and am trying to avoid having to reinstall visual studio.

View 3 Replies View Related

Solutions And Projects: What Are They And How Do They Help The DBA

Mar 10, 2006

I guess the Subject line sums it all up, but I need some experienced explanation of what do a solution and a project represent, and how do I use them to my advantage.

Is a solution an entire database? If so, how can I create a solution from my existing databases?

Are either of them a way to collect together scripts etc which will be run against a production database when the solution is rolled out?

What is a project? Is it a single set of scripts related to an upgrade to a database? If so, can it be executed as a single entity? How is the sequence of execution controlled?

And so on and so on....

2005 is such a step backwards for DBA's with all the features we used to have and now don't. If it wasn't for the fact that MS will eventually stop supporting 2000, I frankly see no incentive to upgrade myself.

Ok, OK, flame off.

Can anybody suggest some resources which might give me some insight into these questions?

Thanks,

-Rob

View 3 Replies View Related

Numbering Issues For Projects

Jun 5, 2008

I'm creating an application to track project issues.  I would like to have the issue number start over at 1 for each project.  I would like to have the issue numbers assigned to each issue in sequential order for each project.  Below is a brief example of what I need it to do.  I don't know where to even start to try to figure this out.  Thanks
ProjectNumber, IssueNumber
TEST0001, 1TEST0001, 2TEST0002, 1TEST0003, 1TEST0003, 2TEST0001, 3TEST0004, 1TEST0003, 3TEST0002, 2TEST0005, 1

View 18 Replies View Related

Counting Projects In A Column

Mar 30, 2001

I have a column called line_number and a column called projectid's.

I need to count count the projectid's as they occur in the line_number
column.

This is how I need the columns to look.

projectid line_number
111 1
111 2
111 3
222 1
222 2

I have written a cursor to get all the data into the table. But not sure how to get this column to count distinct projectid's.

I really appreciate any help.

Thanks again,
Dianne

View 2 Replies View Related

SQL 2005 DTS: Can't Find In Projects...

Sep 5, 2006

I have recently switched to SQL 2005 and have been following this guide to create a new DTS project.

The only problem is the "Data Transformation Project" option does not show in my list of available 'templates'.

I double checked the install using the add/remove programs feature to update the installation -- all components under the business intelligence section are installed.

Here is the step by step of what I am doing:

1. Launch SQL Server Business Intelligence Development studio.

2. File --> New Project

3. Under the Business Intelligence Projects I am looking for Data Transformation Project but do not see it listed.

Here is what I do have:

Analysis services project
Integration services project
report model project
import analysis services 9.0 database
report server project wizard
report server project

Anyone know what the problem is/where I can find DTS?

Thanks,

Zoop

View 1 Replies View Related

Access Data Projects

Jul 23, 2005

Hi,I wanted to know if Access Data Projects is a good option to choose fora SQL Server Database Frontend. The other option is C#.The database will be accessed by multiple users (around 100 users) on aLAN. ADP looks viable coz the users are used to working on a MS accessdatabase.Please post your replies with reasons as to why you think your choiceof f-end is betterCheers!

View 2 Replies View Related

Cannot Create SSIS Projects

Jun 21, 2007

When i create a new SSIS project, the system alert will popup a window to show 'Constructor on type 'Microsoft.DataTransformationService.wizards.ETLProjectInitializer' not found'



I met this kind of questions more than 3 time.



Reinstall VS2005?

How should i do?

View 1 Replies View Related

Setup For School Projects

Nov 9, 2006

How do I install / setup SQL server 2005 so that I can use it for my school projects. I am learning C# and web service programming that supports connections to an SQL database. I need to be able to use it as a "local host" that can connect to Visual Studio 2005.

View 7 Replies View Related

Error In SSIS Projects

Feb 20, 2008

Hi All,


I have a SSIS package.

Very Simple one.

Two OLEDB connection for SQL Server.

I am trying to copy data from a server to another server by column mapping.The source Server is SQL 2000 and Destination is SQL 2005.Everything is ok.. like connections. As there are another two EXECUTE SQL Task, which are executing some sql in the destination server (SQL 2005).All all those two task is ok
But when i am debuging the project all the following errors occurs

1.[OLE DB Destination [121]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict".

2.[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (121) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

3.[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.

4.[OLE DB Source [1]] Error: Setting the end of rowset for the buffer failed with error code 0xC0047020.

5.[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

6.[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
a


Any solutions ??

View 7 Replies View Related

Can't Run SSRS Projects SSBIDS

Jul 9, 2006

I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...

Package Load Failure

Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.

I also tried to create a new Reporting services project and I got the following error....

Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.

Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.

How can I fix this problem?

Thanks,

Gary

View 5 Replies View Related

Access 2003 Projects As Front-end?

Aug 8, 2005

We use SQL Server 2000 on the back-end of our directory web site and ASP on the front end which works fine. However, for my own uses (since I don't create the asp and have to pay a programmer), would it be better to set up an Access 2003 project for my own data entry forms, standard reports and quick searching?

What would be the negatives of this approach. Remember, this is just for me.

Thanks in advance,
Kelly

View 6 Replies View Related

Organizing Report Projects / Directories?

May 3, 2007

Hey All,

I'm tring to figure out the best way to organize my reports.

When I create a new Reporting Service Project throught the 2005 .NET IDE, I'm allowed to have 1 folder in the project to deploy to. I've tried adding folders under the default Reports folder, but I haven't found a way to do this. I'd like to be able to add more directories so I can deploy them right to the server, and they will be in the proper folders, with the correct access rights.

A developer here has offered the approach of One Report - One Project. I don't want to do this because the reports have so much in common, like datasources, that I don't want to be flipping back an forth from one project to the next.

I did also look to see if there was a way to assign a dircetory to each report, rather than the project level, but I didn't see way to do that. I also, tried to add folder through the Windows Explorer and see if I could get around this restriction, but no luck there either.

Anyway, How is everyone else organizing they projects?



Eric Wild



View 1 Replies View Related

Moving And Renaming SSIS Projects

Mar 28, 2007



Say I created a new ssis Project and allowed the project to created a subfolder .. say both the project and subfolder are called x123.



I now want to rename the project to "Mycompany.MyProject" and want to remove the subfolder.



Possible?



Trying to avoid this, I made a copy of the parent folder, and manually tried to copy and paste all objects .. but am getting errors with connection manager entries.



Thanks for any help or information!

View 3 Replies View Related

Moving SSIS Projects To Another Server

Oct 23, 2007

I need to move SSIS packages from our development server to our production server. I need to move those projects in a manner that would allow me to modify them on the destination server. The build option seems to move an executable only. Is there a way to move the entire package to another server?
Thanks,
Ed

View 3 Replies View Related

Transact SQL :: Should Unicode Types Be Used For New Projects?

May 20, 2015

Should Unicode types, like nvarchar, be used when creating new databases that are used by new applications?

View 11 Replies View Related

Need Some Examples And Small Projects On Ssis

Mar 30, 2008

Am new to SSIS, I saw only few examples from the textbook but i need to learn a lot from the ssis , so can any one suggest me where can i find good examples and small projects , so that i can get more practise on the ssis.


Thanks ,
Raj

View 3 Replies View Related

Deploy Report Projects At Client End.

Dec 20, 2006

Hi,

We are using Microsoft Reporting Service 2005 to develop reports. The
reports are pointing to the Analysis Services database.

We want to move the report project developed to another machine. Basically
we want to deploy the reports at the client end.

I have found the below url that mentions the steps for SQL Server 2005
http://support.microsoft.com/kb/842425

Is this the only way to acheive the needed functionality or is there any
command line utility available that does this? or any other
simple procedure to do this?

We want to give the client, simple instructions to deploy the report project.
Any help would be appreciated.

Thanks in advance,

View 1 Replies View Related

Sharing Data Flows Between Projects

Nov 29, 2007

We receive data files from different external customers, and these files have identical layouts.

I'm planning to set up a package for each customer. Each package will contain a flat file source -> OLEDB transformation dataflow, (followed by other customer-specific data flows).

What I'd like to do is just create this dataflow once, parameterising the flat file and table names. Is it possible to include this dataflow in each customer package so that if the flat file layout changes, I can just modify the connection managers in the one place, and then recompile each package to pick up the changes?

Any advice appreciated.

View 8 Replies View Related

Missing Projects/templates Options?

Mar 30, 2007

I have a limited selection of projects.

I want to be able to create business intelligence project for reporting but the business intelligence project option is not there when I go to file/new/project.

When I first installed visual studio I chose visual basic/web development as the preference would this prevent other project types from being displayed?

View 1 Replies View Related

Can't Create/Use Database Projects Is VS2005

Dec 9, 2005

hi,

View 1 Replies View Related

Project Types When Creating New Projects

Nov 12, 2007

Hi all,

I want to create a new Business Intelligence project by using Visual Studio 2005. However, I cannot find that item in the menu.

Is that necessary to install SQL Server 2005 in order to make that project type present? Or are there any other way to create a new project of that type?

Thanks!!

View 5 Replies View Related

Solution/projects/package Organisation

Sep 22, 2006

I would like to create a set of packages which could be used as a basic package for other people. This package /project/solution should be used in a way that another a person could manipulate it in BIDS nad save it as a stand-alone package.

I already created some child packages and one package which should act as a "template" for developing a new package. The devloper should integrate existing child packages very easily.



All developers will share the same network directoy where all the solutions/projects/packages will be stored (which is not a problem to realize it) But how can it be organized that you can have a basic package which can be used as a general "template"?

Does anybody have a good idea, how this could be organized?



Norbert

View 1 Replies View Related

How To Remove Projects And Reports From Web Browser

Jan 17, 2007

I am creating, building, and deploying reports via a web browser interface in SQL 2005 Visual Studio. There are a few projects that I no longer want the masses to see when the go to \servername
eportserver. I have deleted all files associated with the projects and reports, and removed them from within the report server, but when I open the web browser I can still see the old projects and open the reports.

Where is the browser getting this information even though the data doesn't even exist as far as i can tell, and how to I actually delete those entries that i no longer want seen.

I have heard that I can go the actual web page itself, and delete the items using "show details", but I am unfamiliar with where exactly that is and how to use it.

Any advice or help would be greatly appreciated - thanks everyone!





View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved