.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

c# in bids 2008

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
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") >

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

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

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

Express 2008 R2 w/ Advanced Svcs - what BIDS capabilities are provided?


I have BIDS on my desktop as the result of a Visual Studio 2005 Professional installation.  Neither the VS 2008 nor the VS 2010 installs included an update to the BIDS dev. environment, so I'm trying to find out if there's been any update to BIDS and what the SQL Express with Advanced Services brings to the table.

Microsoft's product pages say that it includes BIDS, but is it the VS 2005 version or something newer?  See the Development Tools table at this link:      http://msdn.microsoft.com/en-us/library/cc645993.aspx


Training on Performance Point 2010 and SQL Server 2008 BIDS



Me and my team are developing a POC in Performance Point 2010 using SSASCubes,we are planning to recommend trainign for the team  but i had a couple of questions.

1.The Team is totally new to this technology as we dont know what is .NET,MOSS 2007 and SQL Server 2008 R2.

2.Does working in PPS 2010 requires basics of Sharepoint 2010 and .NET,if yes then what are the areas we need to look into it before proceeding with PPS 2010 training


Can anybody kindly guide us with the same




Cannot open TDS file in BIDS 2008 SP2!

I installed SQL 2008 Standard edition on my computer Windows7 Ultimate 64-bit. The installation went fine and I am able to use my SSMS to execute SQL scripts.

However, when I try to open a TDS file in BIDS, I get the following error message:

Microsoft Visual Studio is unable to load this document:
To design Integration Services package in Businesss Intelligence Development Studio (BIDS), BIDS has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install BIDS, run SQL Server Setup and select Buisness Intelligence Development Studio.

Per Microsoft's recommendation, I installed SP2 but it did not help. Could you provide your help on this?

Thank you,

BIDS Error loading 'Package.dtsx' in 2008


So everything was working grand. I had both SQL2005 and 2008 installed and were working together just fine. Then I installed 2008R2. And everything was still fine minus the fact that I couldn't run anything with the dtexecui.

I have 2 computers that mirror each other in what's installed on them. SQL2005/2008/R2 were installed on both of them. Then when I started having package issues, I uninstalled R2.

Computer A works fine. After I uninstalled R2, I reinstalled the components from the sql2008 disk and packages work/open/run with dtexec/ui

On Computer B (which is the more important one of course) I get this error when trying to open a package (in bids).

Error    4    Error loading 'Package.dtsx' : Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..

And then it gives me the little red x in the right corner.

I tried re-registering everything based on this post http://social.msdn.microsoft.com/Forums/en-IE/sqlkjsetupandupgrade/thread/5ed7480b-2ca5-48de-bd3b-4b3752237c31 and that didn't work.

Then I uninstalled SQL2008, reinstalled, applied SP1, it still didn't work. Then I re-registered things again and it still d

BIDS 2008 Crashes when preview a large report

Studio 2008 SP1 BIDS crashes whenever it tries to render a large report. It does not matter if the report was created with the wizard or manually. It does not matter if it a stored procedure or just SQL. We have several developers in our shop and we have all experienced the same problem. We have to limit the result set with something like "SELECT TOP 1000 ..." while we are developing and then remove the limit or filter when we deploy. After it is deployed there is no problem with the reporting engine rendering the html. The problem is only in Visual Studio 2008 BIDS. When it tries to render a large report it crashes. I think probably because it not rendering html but attempting to draw a representation of the report in the client area of the window. We would like to see a better solution. Any ideas?

BIDS SQL 2008 sp2 "The query processor could not start the necessary thread resources for parallel q


These cubes have been working in SQL 2005 on another box.  I copied the SQL db and the SSAS Project over to this new box and a fresh install of SQL 2008, sp2 Std Ed, 32 bits. Box has Server 2003 R2 Enterprise Ed SP2,

• 2x 2.3GHZ
• 12GB RAM
• D: 120GB SSD Drive Partition For Data
• C: 73 GB Drive Partition for System
• 1 GB NIC

A few of the dimensions will not refresh, they give the message  
"The query processor could not start the necessary thread resources for parallel query execution.; 42000"
The dimension I have been testing has 34 attributes, all directly related to the key attribute, and no hierarchies. There are 246,000 unique members in the source table. If I make another dimension from the same source table, it refreshes fine as long as there are only a few attributes, but when I add the rest, I get this message again.

Drive C, where Visual Studio is installed, has 69 Gb free disk space. The SQL and SSAS data are on D also has 69 Gb free.

Why was SQL 2005 able to handle this, but SQL 2008 cannot? I am thinking of uninstalling 2008 and going back to SQL 2005. Other suggestions?





Unable to add reference in BIDS 2008


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

BIDS 2008 hanging when opening package


Ideas are extremely welcome here.

I have a fresh install of windows 7/64, sql 2008 sp1, visual studio 2008 sp1. Fresh as of last week. BIDS installed just fine - nothing to worry about there. Everything was working fine with my packages and then suddenly now they practically won't open.

If they decide to open I get the nice little "Visual Studio is busy - if you encounter this problem often please report this to Microsoft" error in my tray while it's trying to open. So I wait. And finally it will open but I can't do anything. On all of them DelayValidation = True.  It does this both on "Work Offline" and "Work Online". And thing is they were working just fine. I imported them into a new project. Same deal.

When I restart my computer and try to open them again I get the same response. I've nuked my suo file before opening every time. Same deal though. I don't have any addon installed (no resharper - no bids helper).

Visual Studio isn't pegging the processor or ram - just what I normally would see.

Is there some magic setting that I need to flip to make them work again?


Explanation on Aggregation Design Tab in BIDS for SSAS 2008?

Is there info on how the new aggregation design TAB in BIDS for SSAS 2008 works? It looks great but I have no idea what it does and how to use it. Is that just me?

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)<

Parameter error writing to excell 2007 file using SQL 2008 Server Agent JOB, works in BIDS.


I am getting the following error message when I try to run a script that writes to an excel file calling my Package with a SQL 2008 JOB.

Executed as user: xxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Option "12.0;HDR=YES;" is not valid.  The command line parameters are invalid.  The step failed.

This same package runs correctly if I execute it in dev mode in BIDS.  I had to set 64bitmode to false in Dev mode to get it to work.  I set executable options in the job step to 'run in 32 bit mode'  The error message indicates to me it is trying to run in 32 bit mode which should be correct but it doesn't like the extended parameters. .   

Here is my connection string from the data sources tab on the job

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\xxxx.xlsx;Extended Properties="EXCEL 12.0;HDR=YES";

This was filled in ny the connection object for me.  I have read the article closely at http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html and still can't figure out what I need to change. 

SQL 2008 BIDS - data tab / editing SQL code


We have been creating reports in SSRS/BIDS 2005 for years and now we are creating them in SQL 2008 BIDS.  We know that the Design / Data tab has gone away and to get the new version of that we go to View > Report Data.  This brings up a tree of datasources and fields, etc.  And I see where I can create a new query.

Our question is - in SQL 2008 BIDS where to we go to edit the current SQL code?  Used to be the data tab in design view, but that is gone.  I cannot find anything on this on the boards, books on-line, etc.  I must be missing something very simple, but it's driving me crazy!

Any guidance is appreciated.



Althea ADSBI

I have read that having both BIDS 2005 and 2008 installed on my PC could be a problem.


I am trying to deploy an SSIS package through dtutil.

I am getting an error 'Could not find stored procedure sp_ssis_putpackage'.

I have read that having both BIDS 2005 and 2008 installed on my PC could be a problem.

Does any body know how to get around this error?

Mr Shaw

installing BIDS 2008 Requires Product Key


Hello, I am trying to add Business Intelligence Development Studio (BIDS 2008) for Visual Studio 2008. 

I am trying to add this feature to my existing SQL Server 2008 R2 Standard instance on a Windows Server 2003 x64 box.

When I attempt to add a new feature as part of the SQL Server 2008 setup program, I am prompted to provide a Product Key or select Evaluation or Express.  To my knowledge there is no Product Key that was ever given for SQL Server 2008 as part of my media kit.  The reason I know this is cause the media itself says nothing about requiring a Product Key, however other media in the kit does say it requires Product Key.  I am leary about selecting Evaluation as I do not want it to impact the already installed SQL instance.

Is there a way to work around this to get BIDS installed?  thank you, mark

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