.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

Unable to add reference in BIDS 2008

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

Hi there,


I am trying to build packages Programmatically, added a Script Task and tried to add some references from DLLs. I got an error message showing that there is no template found, and from the event viewer of windows which tells me to run 'VSTA.exe /installvstemplates'  or 'devenv.exe  /installvstemplates'. I have run these two command and reinstalled the SQL server 2008, but still unable to add any references to the project.


Can someone tell me what I can do for fixing this issue? Thanks in advance.


The error msg:


Integration Services Script Task
No template information found.  See the application log in Event Viewer for more details.



In the windows event viewer:


Event Type: Warning
Event Source: Visual Studio - VsTemplate
Event Category: None
Event ID: 1
Date:  12/4/2008
Time:  4:26:03 PM
User:  N/A
Computer: COW76957
The global template information is out of date. Regenerate the templates by running 'VSTA.exe /installvstemplates' or r

View Complete Post

More Related Resource Links

SQL Server 2008 R2 BIDS PageHeader's PrintOnFirstPage=False Not Behaving Like SQL Server 2008 BIDS

I have recently upgraded from SQL Server 2008 SP2 Enterprise edition to 2008 R2 Enterprise, and was in the process of validating that the process did not have any adverse affects on my existing 150 reports originally designed and managed via BIDS 2008. Several reports were designed where the first page has a header different from the rest of the pages.  I created the generic header in the PageHeader and set PrintOnFirstPage to False.  This worked great in 2008...but in 2008 R2 the real estate on the first page is not "freed," so the first page looks like it has an enormous top margin when rendered as a PDF. Even playing around with the visibility of the text box doesn't eliminate the whitespace - and setting visibility properties was not required to get it to work in SQL Server, which rendered as a PDF perfectly just yesterday before our upgrade! I noticed that there were three patches available, but I did not see a Fix available that addressed this issue, therefore I did not install them as advised on the site. Is there any way to do free up the real estate so my first page can use it (maybe a setting in 2008 R2 that wasn't there for 2008)? Or is this a known bug between the two and a patch/hotfix is in the works? I'd hate to have reports that were specifically designed with certain paging to have to be revisited one by one. Thank you fo

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

Unable to create Web Folders in Windows Server 2008 R2

Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

Unable to modify Maintenance Plans SQL 2008

Been having a problem for a while, in that we are unable to modify any maintenance plans in SQL Server Management Studio. The server is running SLQ Server 2008 Standard on Windows 2003 Standard SP2

BIDS Query Designer very slow in VS 2008

I am in the process of upgrading my Report Server projects from 2005 to 2008.  These reports use an Analysis Services 2005 data source and have queries that are anywhere from 20 to 100 lines of MDX.  After upgrading a report, when I open or save a dataset in the Query Designer, it takes up to 20 seconds.  In 2005, this would happen almost instantly. Running SQL Server Profiler, I see that there is an extensive number (600+) of Discover events going on with the Analysis Services server while the Query Designer loads. My version of Visual Studio is 9.0.30729.1 SP and I am running Windows XP SP2. Thanks, Mitch

SQL server 2008 - Unable to tune a query with DTA

We are on:Verison: SQL 2008 [10.0.2531] on windows server 2008. Both are enterprise editions.When I highlight the query and right-click, then select Analyze Query in Database Engine Tuning Advisor, then click "Start Analysis",  I get the following error in the "Message" column of "Progress" tab of DTA: Cannot initialize tuning. [.Net SqlClient Data Provider] If I click on this, it displays this message: "Cannot find either column 'msdb' or the user-defined function or aggregate 'msdb.dbo.fn_DTA_unquote_dbname', or the name is ambiguous. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count=0, current count=1. (Microsoft SQL Server Error: 4121)Please let me know if you guys have any ideas on this error. Thanks,Sam. 

Unable to set defaultmember via MDX in SSAS 2008 R2

Hi,   I've migrated my SSAS cube from 2005 to 2008 R2. in 2005 I could use the mdx (alter cube currentcube ...) to set the default member based on attribute property of another dimension. With 2208 R2 I'm unable to set the value. The mdx that I'm using in 2005 is as follows: alter cube currentcube update dimension [Time].[Time Hierarchy], default_member = tail(filter([Time].[Time Hierarchy].[Day of Month].members, [Time].[Day of Month].currentmember.membervalue  = CDbl([Cube Defaults].[Default Values].Properties( "Default Time Key" ))), 1)(0); This used to set the default member to whatever the Default Time Key attribute is set to. For ex. 01-Jan-2010 or 01-Jun-2010 etc.  This doesn't work in 2008 R2 anymore and the default member for the Time dimension is set to "All". Any ideas? Do I need to change something in the above script to get it working? All help would be very useful! - Sourabh  

Unable to Backup Service Master Key on SQL 2008 Express

Hi I am attempting to do a backup of the Server Master Key but it fails. The error message I am receiving is as follows: Msg 15240, Level 16, State 1, Line 1 Cannot write into file 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist. The PC I am running SQL 2008 Express (64 bit) is running on Vista Ultimate (64-bit) SP2. The SQL I wrote is as follows: BACKUP SERVICE MASTER KEY TO FILE = 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey' ENCRYPTION BY PASSWORD = '??' GO Note that the ?? represents the password but is not actually the password for obvious reasons. I am logged in to the PC as a user with Admin permissions.  I had a look at the destination folder, and it shows I have full control. So, I am mystified. If somebody could advise me I would really appreciate it. Many thanks in advance. Kind regards Ross Ross

Unable to connect SQL Server 2008

Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

Unable to load Reg-Free COM dll reference in AppDomain

Retrieving the COM class factory for component with CLSID {E1B87327-4DB5-492E-8AC2-F542BCA3C912} failed due to the following error: 80040154. I have a .net dll refering Reg-Free COM DLL, when try to load my .net dll in AppDomain i get above error. If i regster it works fine. Also it works fine if i refer my .net dll from stand alond exe(works fine in both COM register and un-register scenarios). AppDomain is not recongnising Reg-Free COM dll.ravi kumar reddy

Unable to start T-SQL debugging SQL Server 2008

I'm getting exactly the same problem described here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/dcc851e7-35d7-492a-b15c-7dffe47110ed --------------------------- Microsoft SQL Server Management Studio --------------------------- Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'myserver'. Click Help for more information. --------------------------- OK   Help   --------------------------- I've followed advice with regards to Windows Firewall, however it's disabled on both client and server.  I've tried using a SQL Server account but haven't had any more success.  I've also checked the windows event logs on both the client and the server and can't find anything.. Lastly (not sure if this is useful or not) I tried attaching to the Ssms.exe process from Visual Studio 2008 and I get the following output when I try debugging:  ... C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.CommonIDE\\Microsoft.VisualStudio.CommonIDE.dll: Cannot find or open the PDB file. C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.DataWarehouse.VsIntegration.dll: Cannot find or open the PDB file. 'Ssms.exe': Loaded 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SQLDE.dll' First-chance exception at 0x7c812a6b in Ssms.exe: 0

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

c# in bids 2008

I have an old VB 6 program that I used to create new table partitions annually.  The program used SQLDMO.  We've upgraded to SQL 2008 since I used it last and it no longer works with SQL 2008.  It’s time for it to be upgraded anyway, so I thought I’d see if I could use the script task in BIDS and create a task to do the same thing using SMO.  I haven’t developed a thing in C# so I’m very much a rookie, and all the examples I find are for using C# in VSS – not in BIDS.  Can anyone point me to a good place where I can see samples of C# code in BIDS?   Here is what my VB6 code looks like, that I’d like to replicate in BIDS 2008 in a script task.  I’d like to do it there because I don’t have VSS.  Is it possible?   Sub Main()   Dim svr As SQLDMO.SQLServer2 Dim strFile As String   Set svr = New SQLDMO.SQLServer2 strFile = "c:\2011Tables.txt"   With svr     .Name = "MyServer"     .LoginTimeout = 15     .Login = "sa"     .Password = "MyPwd"     .Connect End With        Open strFile For Output As #1     For Each View In svr.Databases("LIVE").Tables     If InStr(View.Name, "2010") >

Error on VS 2008 Class Library project: are you missing an assembly reference?)

http://msdn.microsoft.com/en-us/library/bb153523(office.12).aspx Working with ASP.NET 2.0 Web Parts and Windows SharePoint Services 3.0 Based on the above MSDN Walkthrough, I created a Class Library VS 2008 project. When clicking the Build menu, 11 errors on System.Web.Security etc popped up.  What's wrong? *********************************************** using   System; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; Error 1 The type or namespace name 'Security' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) Error 2 The type or namespace name 'UI' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Unable to install SQL Server 2008

HI, I am uable to install SQL SERVER 2008 in my machine. The setup checks in the pre requisites and it fails for a server reboot. It prompts me to reboot the machine. I have already rebooted my machine thrice but still its prompting me for a reboot. Can anyone guide me through this?     Regadrds, Shannid
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