.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

BIDS wont let me edit script tasks, Package wont open without a "temp" folder in appdata???

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
I have a very stupid problem, because the way BIDS works is just hilariousy idiotic.    Short Story: 1) When i try to edit script tasks it will complain about "failed to create project at some random path in temp folder" and wont open anything. I cannot edit script tasks anymore. THe project is essentialy dead to me. REboot or restart wont help. I spent five hours on this project and i dont want to do all that work from scratch! 2) I cannot port my solution to antoher computer or place because it links to the files in appdata/local/temp folder of the pc for some reason. If i delete that folder or port the solution, it will complain about some file in temp folder called "3jews....tmp" and will say that solution is unopenable. Need help to resuce my project and be able to continue working on it!   Long Story: When you make a project, BIDS stores its files in a separate folder: a solution file, a project file, a package file etc. You might have thought, you can now carry your solution over by copying this folder. WRONG! The BIDS actually stores files of  the solution in /Users/name/AppData/Local/Temp folder! And It cannot open a solution/package/project without files from that folder, now what kind of idiotism is that?   It all started with BIDS not saving my script task changes, then telling me "cannot create project in folder

View Complete Post

More Related Resource Links

Change Item order wont work for folder items

Hello. Links lists in Sharepoint 2010 have Change Item Order Action which can order your items. I added new content type based on folder content type to my list. And When I want to order my folder items with Change Item Order action Sharepoint sorts my items randomly. For example with 4 folder items it sorts it right in 3 or 4 times. I can't see any rule in it's behavior sometimes it works sometimes not. For Link list items everything is OK. Anyone have an idea? Thanks.

Form that is part of workflow wont open in form library


I am having an issue with my form. I have created a sharepoint sequential workflow using visual studio and as a task the user has to fill out an infopath form. When the form is submitted as part of the workflow is then saved to a form library. My issue is when I try to open the form in the form library I get the message "The form has been closed". 

I have check the Central Admin/Manage Form Templates and my form is here, status="Ready" and workflow enabled. But my form doesnt exist in the sitecollection/FormTemplate library. So I believe that when I try to open the form in the browser that template cant be found. Why I say that is when I open the form with the info path client, I get the message "The form was created with a new version of the form template. InfoPath cannot find the new version. Do you want to open with an older one" 
If a infopath form is part of a workflow and it be saved in a form library and then open, if so how?
Am I publishing the form incorrectly - I publish to network location. Then install my feature.
Do I need to associated the form template with the form library or should the feature installation take care of this?


- FormTemplate Library doesnt appear in site settings, I

SQL 2008 express wont open this morning


Everything was working fine yesterday afternoon before going home.. shut down with no issues and this morning when i try to open SQL i get  error message with the following, im on a deadline with this project and cant afford to lose what i have setup already. Is there anything i can do to correct whatever issues there may be?


TITLE: Connect to Server


Cannot connect to local.



A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)


cannot edit data flow tasks in BIDS 2008


An error prevented the view from loading. (Microsoft Visual Studio)


You must have a license to use this ActiveX control. (System.Windows.Forms)

Program Location:

   at System.Windows.Forms.AxHost.CreateInstance()
   at System.Windows.Forms.AxHost.GetOcxCreate()
   at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state)
   at System.Windows.Forms.AxHost.CreateHandle()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateDdsView(Control parentControl)
   at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.CreateDdsView(Control parentControl)
   at Microsoft.DataWarehouse.Controls.DdsDiagramHostControl.set_ComponentDiagram(ComponentDiagram value)
   at Microsoft.DataTransformationServices.Design.ControlFlowControl.set_ComponentDiagram(ComponentDiagram value)
   at Microsoft.DataTransformationServices.Design.DtsPackageView.CreateControlFlowEditor(VsStyleToolBar pageViewToolBar)
   at Microsoft.DataWarehouse.Design.EditorWindow.EnsureViewIsLoaded(EditorView view)<

Add new item link wont add document to sub folder


Hey everyone,

I have a list view web part that I am adding programatically so that everytime a certain site is created, a list is created, and that list is rolled up via the webpart. It has worked for some time now, and still works for sites that have been created, but for new sites I am getting a weird issue. When I have a folder in the list, and click the Add New Document link while inside that folder, it will place the document in root of the list, and not in the folder.

SPList list = SPWebExtensions.TryCatchGetListByTitle(web.Web, "Group Resources");

     lvw.ListName = list.ID.ToString("B").ToUpperInvariant();

     lvw.ID = "GenericListName";

     lvw.TitleUrl = list.DefaultViewUrl;

     lvw.WebId = list.ParentWeb.ID;

     lvw.ViewGuid = defaultViewGuid.ToString("B").ToUpperInvariant();

     manager.AddWebPart(lvw, "bottomZone", 0);

     ListViewWebPart savedLvw = (ListViewWebPart)manager.WebParts["GenericWebPartName"];

     // Get the view used in the web part by using reflection


file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

Textbox text populated by Session Variable wont update into SQL with new text


Hi everyone, I have what I think is a weird issue. I send text from one page to another via Session Variable. When page 2 loads, the text box has the session text set, but if the user changes the text and clicks the button, the SQL database is update with the original session text. If I remove the redirect from the page 2 button_Click method, then, the page refreshes with the textbox reverting to the session text and thr SQLDataSource has the session text added to it.

Why would the button click cause the textbox refresh with the text from the pageLoad before updating the data source?


Partial Class _1
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Session("UpdateProd") = "Have some text here to send to a textbox on page 2"
    End Sub
End Class

Partial Class _2
    Inherits System.Web.UI.Page


Moved from WinXP to Win7 - don't see choice to open file in read only or edit mode


I just recently moved from Win XP Pro SP3 to Win 7 32-bit Pro. I am logging into domain X normally. Our Sharepoint 2007 server authenticates only on domain Y. So I start Internet Explorer with "run as different user" and provide my domain Y credentials. All fine. 

In win XP, after I did this, when I click on an Excel file on Sharepoint, I would get a dialog asking if I wanted to check out and edit or open as read only. 

In win7, I don't get that choice. The file simply opens, and I get a bar at the top which allows me to check out the file if I wanted to. 

How can I restore the functionality I used to have, with the dialog for checking out the file before opening it?

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


Web Deployment Projects wont split dll's



When i try to build my Web Application project using the Web Deployment Projects the dll's aren't splitting into seperate asemblys as i have set it to.

My output look like this:

------ Build started: Project: ClassLib, Configuration: Release Any CPU ------
ClassLib -> C:\Users\Heu\Desktop\SBCms_Release_1_0\ClassLib\bin\Release\ClassLib.dll
------ Skipped Build: Project: SBCms Website, Configuration: Release Any CPU ------
Project not selected to build for this solution configuration
------ Build started: Project: SBCms Website.vbproj_deploy, Configuration: Release Any CPU ------
if exist ".\TempBuildDir\" rd /s /q ".\TempBuildDir\"
C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_compiler.exe -v "/SBCms Website.vbproj" -p "C:\Users\Heu\Desktop\SBCms_Release_1_0\SBCms Website" -u -f .\TempBuildDir\
Running aspnet_merge.exe.
C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin\aspnet_merge.exe .\TempBuildDir -prefix test_ -a -copyattrs
aspnet_merge : warning 1013: Cannot find any assemblies that can be merged in the application bin folder.
Successfully merged '.\TempBuildDir'.
if exist "C:\Users\Heu\Desktop\SBCms_Release_1_0\SBCms Website.vbproj_deploy\Release\" rd /s /q "C:\Users\Heu\Desktop\SBCms_Relea

Simplest way to open my script files?

Hi everybody, I usually save my scripts in the default place offered my SSMS (the location of that place is hard to find). However, if I open a script from a disk from different location, now when I need to open my saved scripts it looks in that folder and not in the folder where all my scripts are kept. How can I open the script from the right place if I don't remember where that folder is and I don't want to re-start SSMS? Thanks a lot in advance.  Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

PowerShell script to add/edit ContentEditor webpart on SharePoint 2010

Hi all, I'm new to PowerShell scripting with SharePoint. Following are the requirements that were given to me. Can any one direct me in the right direction interms of writing the script and how to save and execute the script? I am aware of Cmdlets. 1. Cycle through all sites in site collection 2. For each site, retrieve all document libraries 3. Look for specific CMV document library name (ie value communication, key business drivers, etc)          o add content editor web part if doesn't exist          o add/update appropriate description based on the document library name Thanks in advance...

using application configuration file in AppData special folder

Hi! So I understand it is a best practice to save the application configuration files under the AppData folder, rather than in Program Files, since UAC will restrict write acces to the Program Files folder, which is fine. Now, saving the configuration file to another location is no problem, using the SaveAs method. However, when I load the application, I expect some settings to be read. From what I know, this is done either using direct calls to the ConfigurationManager class, either initializing a Configuration object. For the first case, a example is this: if (ConfigurationManager.AppSettings["Title"] != null) { this.Title = ConfigurationManager.AppSettings["Title"]; titleTextBox.Text = ConfigurationManager.AppSettings["Title"]; } For the second case, I would use it like this: Configuration config = ConfigurationManager.OpenExeConfiguration( ConfigurationUserLevel.None); string setting = config.AppSettings.Settings["Title"].Value.ToString(); So, if the application runs in the Program Files folder, an exception is thrown when I save the file. However, if I save the file using SaveAs and save it to AppData folder, obviously, when loading, the settings are not loaded from the AppData folder, but from the configuration file existing in the Program Files folder. One way to solve

Open a password protected package in C#

Hi - trying to write an app that opens packages in C# but have hit a stumbling block - how do you open a package that is password protected? The code I am using is: app.LoadPackage(packagepath, null) But I can't see how to pass the password in, so the code throws an exception. Cheers, James James Beresford @ www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

Claims to windows token service wont start in Central administration

Not sure if this is a bug or some setting I just dont understand but I cannot get the claims to windows token service from manage services to show as started. When I click start I get this error in the event viewer: An attempt to start/stop instance of service Claims to Windows Token Service on server <SERVERNAME> did not succeed. Re-run the action via UI or command line on the specified server. Additional information is below. c2wts (DOMAIN\sp_farm) I have searched and searched for an answer. This thread http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/6b865ead-970b-4460-9dcf-1cc6d6d8530b talks about needing a connection to the internet, but my server is connected to the internet so i think i can rule that out. Also I have read that c2wts depends on the crypto service. I have run this command with no success: sc config c2wts depend= cryptsvc I can start the c2wts service through services.msc and it is succesful. But central administration still shows it is stopped. I have also re-run the installer in repair mode, and re-run the initial configuration wizard, maintaining all of the same settings as the previous installation. That didn't help. Basically, I'm out of ideas and I cant find much about this on the web. Any ideas?

Powerpoint ppsx files open as read only in sharepoint with not option to edit

With Powerpoint 20007 in sharepoint(MOSS 2007) the PPSX files are opening in read only mode with no option to edit to be found. 2nd issue is ppsx files do not open on any persons computer as a show.  Is it possible to change this? How do I change this so I can edit the slides? Current "bad" solution is to save to local drive than upload them over the location  on sharepoint. This post was redirected by moderator from: http://social.answers.microsoft.com/Forums/en-US/pptshare/thread/9674b463-2195-4bbd-a2e7-526b8cfa4491

need a simple login page cus my hosting provider system wont allow me to have more than one database

I dont really write html code too well  but I manged to get my web site developed and deployed using the built in features such as drag n drop, master page and user account authentication that make web developing almost a codeless experience. However; my hosting provider system wont allow me to have more than one database, this causes problems becasue when I developed my web app using vb2010 web developer (asp.net v2) I used the built in web config tool to manage users for my site, now after I deployed to my domain it all worked ok with the exeption of the login page, when I tried to log in the system threw a error message saying "database not found." or a page of "gobble-dee-gook" that says the same thing When I contacted support (my hosting provider) they said i have to create a table of users in my database file via 2008 sql server, thats ok I can do that, but my real problem is I dont know how to write appropriate code to reference the table. So heres my problem:  I just want to have some kind of login page with a couple of txtboxes and a click button that maybe using the VB code behind or html checks the input variables "username" "password" against something that is hard coded into vb a string variable or a constant and then branches to Mainmenu.aspx if successfull. I just need it real simple, no fancy stuff just a login s
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