Problems With BIDS After Reinstallation On Other Partition
Jan 10, 2008
Hi there,
I've had BIDS installed on the first partition (C in the standard location. Since the space has run low, the admin has un- and reinstalled BIDS on the similar location on another partition (D.
The problem is, that when I open VS I can see "Integration Service" as a known module on the splash screen (even in the Help->About dialog), but when I try to open a solution with an SSIS project (dtproj) an error dialog occurs with the message that this project type is not supported.
The user who installed BIDS does not run into my problems! So I've tried to run devenv /ResetSettings which didn't make it right, so I'm a little messed up.
I am a newcomer for SQL Server. Yesterday my NT was down, and had to be reinstalled. Therefore SQL Server 7 used has to been reinstalled too. Though old data files for SQL Server still exists, however, reinstalled SQL Server 7 cannot use them directly. I just wonder if there are any method or utility that are able to recover those previous data? Thanks very much in advance.
Somehow i messed up some IIS settings for Reporting Services and had to uninstall and reinstall Reporting Services. When reinstalling it, i get warnings about existing Report Server and tempReportServer database so i removed those 2 databases from SQL Server 2000. At the end of the installation, another warning popped up saying I need to initialize the report server manually. I ran rsconfig and rsactivate to initialize the report server. Now i get a no page found error when load http://localhost/reports. I can't seem to get any good documentation on the web for reporting services since it's fairly new. Please help.
I installed Visual Studio'05 on my sys. But it has no BIDS in its pop-up menu and also has no BI project templates. I am trying to build cubes in SSAS. Can anyone help me out.
Can we install BIDS client (no server components) on a separate workstation using a download of SQL Server 2005 Developer edition and not require a separate license for the workstation?
i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately...but essentially i did it the same way as this method...
Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS program sometimes doesnt install? im using 2k5 express products on this machine...
I have installed Sql server 2005 enterprise edition with the All the BI services (SSIS,SSAS,SSRS) . when i try to Install the Tools Like BIDS,documentation,sample databses. I am getting the error that foolowing compentes are already installed on the machine though they are not installed
Error message :None of the selected features can be installed or upgraded.Setup cannot Proceed since no effective change is made to the machine.To continue,Click Back And then select features to install.To Exit SQL Server Setup,click cancel
All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?
Well all bugs are annoying, but this one is particularly annoying because it kills the BIDS session with consequent loss of all changes made since the last save.
Click on a control flow task. Position the cursor so that it changes to the 4-way pointer. Drag the task a little bit. The UI locks up, and then BIDS disappears.
I can't repro this on demand, but it has happened about 6 times in the past month. Anyone else seen this one?
On several occasions I have experienced crashes while running an SSIS package in debug mode. It happens when I start process on Control Flow table and click on Data Flow tab to monitor progress. I have forwarded the error reports and have searched the boards for similar references. Is this problem going to be fixed?
SSIS Data Sources
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) ----------------------
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Visiual Studio 2005 Professional SP1 SP.050727-7600 .NET Framework 2.0.50727
I am trying to create a package in BIDS that reads data from a table and exports it into a flat file (.csv). The file needs to have a row for the header and a row representing the column names as well as the data rows. My problem is: 1.I need to add a value in the header row that is a count of all the data rows. 2. I need to add the year and period based on the year and period in the data rows. (the year and period will always be the same in the data rows)
below is an example of what I want the file to look like (it is a delimited file)
1;Varese;O027200702ACT;F1_V4;BATCH;2326;test company CUSTOMER_ID;BU_ID;YEAR_ID;PERIOD_ID;ACTIVITY_ID;SCENARIO_ID;ACCOUNT_ID;DATA_UNIT_ID;DATA_VALUE 000001;ZA01000001;2007;2;01;1;70;ZAR;.04 000001;ZA01000001;2007;2;01;1;912;ZAR;6080374 000001;ZA01000001;2007;2;01;1;941;ZAR;-.16
The value in bold represent the values that i want dynamically updated...
200702 represents a concatenation of the year and period
When you get an warning from, i.e, OleDb Destination you see an exclamation mark in yellow and then, when you move the mouse over you can't see never the whole message (If long)
How or is there a way to reorder the packages in BIDS? Right now they are ordered by when they are created with the newest ones on the bottom. I'd like to organize these in more of a logical order but am unsure of how to do so.
I have an FTP task that will only work when running in BIDS.
When trying to run as a package on the server or calling the package from a job, I get the following error in the log file:
OnError,<servername>,<user>,FTP Task,{B2F5BB68-C6F8-4EE5-ABC0-71C3636E3E4A},{B7B41A88-18DD-4AD7-8CDE-9E0C1B74DA02},6/26/2007 12:09:11 PM,6/26/2007 12:09:11 PM,-1073573489,0x,Unable to connect to FTP server using "FTP Connection Manager".
I'm sorry but I am so frustrated from searching and trying things! I can't understand why this can't be resolved much easier.............anyway
I am trying to use BIDS on sql server express 2005 after attempting to install the tool kit a couple of times on different platforms. I have installed:
1) VS 2003 (also Visual C# Express on another machine);
2) .net 1.1 and .net 2.0;
3) SQL Server 2005 Express with Advanced services and the tool kit.
The sequence of installs is as follows
1).net 1.1 was there from the beginning
2)VS 2003
3).net 2.0
4)sql server 2005 express
5) tool kit
I see BIDS in the menu but devenv.exe does not exist. I've seen several workarrounds including finding and running vs_setup.msi but those don't work for me either. I am suspecting that the BIDS install conflicts with Visual Studio in any form! If this is true, can someone list those steps to follow to uninstall/re-install the products to get this working?
I would like to report what appears to me to be a bug. I found it while researching an answer for another thread. http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=554926&SiteID=17
Since that thread has not received any further replies I thought I would start a new one to see what answer we can get from MS as well as if anyone else would care to reproduce.
The bug is not a major one and the work around is easy, but it can be annoying.
The bug is this: if I open an SSIS package in BIDS (RTM or SP1) and the only change I make is adding or modifying an annotation and then click on Save and then close BIDS does not save the new annotation or changes made to existing annotations. If I change something other than an annotation then BIDS does save the annotations with the package.
A careful observer will notice that when opening a package and then modifying or adding an annotation that BIDS does not even register that the package has been changed. This is evident by the lack of the trailing asterisk in the title bar after the package name.
In summary if I go into a package for the sole purpose of adding and/or modifying annotations they will not get saved. Workaround: modify something else in the package and then save.
I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.
1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?
2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?
This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.
i installed visual studio'05 on my sys to build cubes in SSAS.But its not having BIDS in its pop-up menu,nor it has BI project templates.Can any one help me out.
When I open a project in BIDS, for some reason it automatically opens a new tab for each and every package in the project, which is both time consuming and a bit annoying.
I don't want to open a tab for a package unless I do it myself.
I'm actually developing a report with some dates on it. I want that when I run this report, a prompt (a window) appears requesting a date (or at least it could be good if a list appears and I can select one of them). Do you have any idea about how can I do that?.
Hello,I'm using BIDS to create a package, and I need to pass in a variable value; how does this new DTS process work, in deploying the package and passing in a custom value at runtime?Thanks.
Does anybody know what this means? I have a SQL source (OLEDB) going to a script transformation as a destination:[DTS.Pipeline] Warning: Component "Add Schemas" (32) has been removed from the Data Flow task because its output is not used and its inputs have no side effects. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.Add Schemas is the script transformation destination. I can't find a HasSideEffects property, and have no idea why this would be a problem.
This seems to ba a common problem, but none of the things I have tried seems to work.
I built a simple job in SSIS. It performs a select against an Oracle 10g db and returns the data to a table in SQL server 2005.
Job runs fine from BIDS but will not run when set up from SQL Server.Data from log:
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 1:17:55 PM Error: 2008-03-27 13:18:01.59 Code: 0xC0202009 Source: TestDTS Connection manager "FSRPT.genesys_dts" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12154: TNS:could not resolve service name ". End Error Error: 2008-03-27 13:18:01.65 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "FSRPT.genesys_dts" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2008-03-27 13:18:01.66 Code: 0xC0047017 Source: Data Flow Task DTS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2008-03-27 13:18:01.66 Code: 0xC004700C Source: Data Flow Task DTS.Pipeline Description: One or more component failed validation. End Error Error: 2008-03-27 13:18:01.67 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:17:55 PM Finished: 1:18:01 PM Elapsed: 5.919 seconds
I set protection level to ServerStorage and saved to SS2005. I am using MS ODBC driver for Oracle. Installed client is Oracle 9.2.0.1. Using TNSNAMES file.SS2005 is installed locally and I am running job under proxy using my credentials.
It is probably something I am just overlooking. I have been crawling the forums for a couple of days. I have no issues (so far) running any other jobs.
I am wondering how to change the default parameters for the Clustering algorithm in BIDS. I set up an initial MiningStructure with the wizard but i want to tweak the
Clustering_Method and Cluster_Count parameters prior to training the dataset but I do not see where to do this..
I have found many references to this issue on the forum, but no solution that works in my case. I believe that I am lacking a fundamental understanding of a security issue so I will attempt to provide as much up front information as possible. I can publish SSRS reports from BIDS to my local computer but when I try and publish the same reports to a production server, I get a login dialog (which I cannot get passed). Here are the particulars. My environment is a home office. I have my computer (which works with the localhost designation) running on a workgroup network (not domain based). My server is another machine on the network (named €œserverone€?). Both machines are running Windows XP Professional. The BIDS project €œDebug€? property page has the TargetServerURL set to http://localhost/ReportServer. The €œProduction€? property page has the TargetServerURL set to http://serverone/ReportServer. I am logged on as an administrator but I cannot publish to the remote server (serverone) from my machine (localhost). I have also tried using the actual TCIP address of the server in place of the serverone name to no avail. I believe that my problem is related to authentication between the two SQL Server 2005 instances running on separate machines on a workgroup based network rather than a domain based network but I cannot find any information that might be useful under these circumstances. Now, here is my workaround (but this seems very wrong). From the logon dialog generated in BIDS, the user ID name was blank. When I attempted to remotely access the Report Manager on the server from my machine, IE tried to logon using the €œserverone/guest€? account. I added an administrator role to the guest account on the server and everything works as expected. As I mentioned before, this seems very wrong. Currently, both machines were set to use the €œlocal system€? account during setup, but I am not even sure what that means. I tried setting the server to use the €œNetwork Service€? account as suggested in one of the forum threads but that did not work. Any help here would be greatly appreciated as I am sure that allowing the €œGuest€? account to have €œAdministrator€? privileges is a bad idea.
Up to this point only two of use, both server administrators, have developed reports. Now we need to add two new report analysts to be able to develop reports in BIDS but limit their access to other server folders, etc. Our report source code is located at G:Visual Studio 2005 Source CodeProjects and all report folders, sln files, etc. are located under the Projects sub-folder. I have shared the Projects sub-folder and given read & execute / list folder contents / read / write / modify rights. They can see the report folders and sln files via BIDS or Explorer but get "access denied" when they attempt to execute one of them. Any thoughts on what I may be missing?
Hi, I have been working on an SSIS project for sometime now. The project files are located on a remote server. Suddenly I am not able to open the solution I get a lot of error messages and all the data flow taks are gone. I later found out that SSIS encrypts packages, so that other users will not be able to see them. Fine, but I have been using the same windows user account for months now. What could be the problem? This is what I get when trying to open the solution:
There were errors while the package was being loaded. The package might be corrupted. See the Error List for details.
And the error list also contains messages saying "Could not load from xml".
