BIDS archives - SQL Server with Mr. Denny
Home > IT Blogs > SQL Server with Mr. Denny >

SQL Server with Mr. Denny:

BIDS

Dec 22 2008   11:00AM GMT

Development of SQL 2008 SSIS Packages Requires SSIS Service



Posted by: mrdenny
BIDS, SSIS, SQL Server 2008

Unlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation.  This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation.

It doesn’t appear that you actually need to have the service running.  I have stopped the SSIS service on my workstation and I am still able to run my SQL 2008 SSIS packages, however I would recommend setting it to manual rather then disabled just in case BIDS needs it running for some reason.

If you try and edit an existing package without the SSIS service installed an error message will be displayed saying that the service needs to be installed.

Denny

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend

Jul 24 2008   11:00AM GMT

How to setup SQL 2008 BIDS to use VB.NET as the default scripting language



Posted by: mrdenny
BIDS, SSIS, SQL Server 2008, Integration Services 2008

If you are like me and don’t know anything about C#, and you don’t want to have to change the script language every time to create a .NET script from C#.NET to VB.NET you can change the default.

 Open BIDS, and select Tools > Options.  On the menu on the left select “Business Intelligence Designers” then “Integration Services Designers”.  In the Script box in the middle of the right pain change the option in the drop down from “Microsoft Visual C# 2008″ to “Microsoft Visual Basic 2008″.

If you prefer C# you’ve got nothing to worry about as C# is the default option.

Denny

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend