.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

SSIS Project Templates Not Showing

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :ASP.Net

Dear Fren's

this is an issue regarfding the SQL Severe Integration Services

I have installed the Business Intelligence Studio through SQLEXPR_TOOLKIT.EXE

but the problem is when i am trying to create the SSIS Project it is not showing the SSIS Project Templates in BID .

I have try to change the location of Templates in Tools --> Option --> project & Solution   but the still the problem is same

Please Help

Thanks in Advance

View Complete Post

More Related Resource Links

Custom SSIS project template vrs package templates

I have created several custom package templates, but they are a little cumbersome to use because there is no concept of macro substitutions like you have with a standard visual studio project template.  From what I've researched so far, you can create a project template from visual studio's file menu: File->Export Template.  This in theory this launches the project template wizard.  My only problem is that this menu item appears to be disabled for SSIS projects.  Is it possible to create custom project templates for SSIS?  I'm  using BIDS 2008.

Visual Studio 2005: Create Reusable Project And Item Templates For Your Development Team


Visual Studio 2005 introduces a new model that lets you define your own project templates and starter kits, something developers have been requesting for some time. Here Matt Milner shows you how to consume, create, and customize these templates.

Matt Milner

MSDN Magazine January 2006

Custom SSIS Data Flow Component Not Showing in Toolbox or GAC

Hello - I have created a very simple data flow component for SSIS (Actually, I am following this example:  http://www.microsoft.com/downloads/details.aspx?familyid=1C2A7DD2-3EC3-4641-9407-A5A337BEA7D3&displaylang=en).  However, when I register the DLL to the GAC, I am unable to find the assembly in C:\Windows\Assembly - even though the GACUTIL says "Assembly Registered Successfully".  Furthermore, after copying the DLL to the PipelineComponents folder for SSIS (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents), it does not show in the "Choose Items . . ." dialog box of SSIS.   I am running SQL Server 2008 Dev edition, Visual Studio 2010 with .NET 4.0, and Windows 7 Enterprise 64-bit edition.  Any assistance/thoughts would be appreciated. Thanks!

SSMS Project templates

I am using SQL2008R2. From SSMS when I try to create a new project three template choices are shown. SQL Server Scripts, Analysis Services Scripts and SQL Server Compact Edition Scripts. Regardless of which one I pick the solution explorer window is empty and there is no apparent way to add anything to it? I suspect the templates are messed up. How can I replace what is there with ones that work? Thanks.Tom

Integrate SSIS project in Windows Form

I have a windows form project in which I would like call a SSIS project passing 2 variables simlutaneously...How do I accomplish this?

SSIS to MS Project

Hi All, My requirements are that I am supposed to export a lot of data from a work tracking system (MS SQL based) to MS Project 2003 or higher. Can any one guide me how I'll accomplish this? Thanks!GBM

SSIS Project Build - Command Line

We are trying to automate our Build and Deployment process for SSIS Packages. Can some one suggest me the way to perform the build and deployment using Command Line.

Adding Oracle table into SSIS project --Oracle error occurred, but error message could not be retrie

Hi all I am new to design SSIS packages,to day I stated creating package SSIS package and adding the Tables,while adding tables,one of the table giving an below error . I verified the table structure it has one "CLOB" datatype. can some body help how to add this table( whole idea of the package is I have Dump those tables with structure and Data to SQL Server 2008 Database)  =================================== Oracle error occurred, but error message could not be retrieved from Oracle. Data type is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at System.Data.OleDb.OleDbCommand.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType) at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV() Thanks in Advance.   SNIVAS

Calling SSIS from Access .adp project


Not sure if this is the right place to ask but I'll try...


I have to execute an integration service package in an .adp project. In other words, click of the button on the adp window has to start a package or a job.


Can that be done? And if yes, how? I've been searching the Web but without success.


Thanks for your help.

Project Templates in VS 2010



I am a beginner in ASP.net world and is a experienced Java developer.

My company is looking to convert the existing legacy applications into .Net. We have many small applications that need to be converted to .Net.

Most of them share the same look and feel with a similar layout, header, footer, admin menu, authentication with Active directory etc.  Rather than every developer going through the same initial steps manually, I would like to standardize and create a base template of the project that everyone can work with. I am also looking into adding the logging framework set up, exception handling (I am thinking of using ELMAH) etc.

I was thinking of using the template option of VS2010 through which I export the template after creating the sample project which then can be used by other developers.

Another option is to create a base project and commit to the Version control which can then be checked out by other developers. They can rename the project and other details.

Any suggestions on which is better ? Or other ideas or options?

Really appreciate your inputs.


WCF RIA Services Project Templates Missing


When I start a new project and select Silverlight as the type of project that I want to create, the WCF RIA Services Templates are not there (Silverlight Business Application, WCF Class Library).  They were there before I installed the Silverlight Developer Toolkit.  I've tried uninstalling and reinstalling the RIA Services Tools but to no avail.  I would like to have these templates back.  

I'm attempting to install this set of silverlight developer tools for Visual Studio 2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b3deb194-ca86-4fb6-a716-b67c2604a139

 In the directories where the VS 2010 templates are stored, the RIA Services templates are not there.

\%Program Files%\Microsoft Visual Studio 10.0\Common7\IDE\ProjectTemplates\CSharp\Silverlight\1033

\%Program Files%\Microsoft Visual Studio 10.0\Common7\IDE\ProjectTemplatesCache\CSharp\Silverlight\1033

Each folder only has:


first ssis project - with master child table


Hello all,

I'm planning to develop a new SSIS project where I have a data in a table (Raw form) and I want to put into our production database. I just want to start with a test project and if you provide me little inside that will be helpful.

Here is what I'm trying to do

Typical order table (Order Header and Order Detail)

Temporary table with raw data which need to import in Order Table.

Order Header contains auto increment primary key which needs to be in order details table. So how should I develop a project where I go thru each record of temp table, write a record in order table, get order id (pk) and write data in order detail table.

Hope it is very much clear.

Hopefully I will get expert advice soon.

Thanks in advance,



mark it as answer if it answered your question :)

Visual Studio Project and Item Templates are missing



I am using Windows 7 Professional and I have VS 2008 and 2010 installed in my machine. Project and Item templates are missing in VS 2008 but it is available in VS 2010. only MS .net 4.0 is installed in my machine. I read that, .Net 3.5 would come as an OS component in Windows 7. I tried executing  devenv /installvstemplates in visual studio command prompt. But VS command prompt is not present under VS 2008-> VS Tools. It is present under VS 2010. Also I noticed that only 5 compressed files are in C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033 folder. I think, I need rest of the files to see the templates. But I am not sure from where I can get those files. Any help on this would be appreciated.

Thanks In Advance,




Adding multiple packages to the SSIS project Options

I've got appr. 100 packages on a SQL server 2005 server, I need to
edit them and import to the new SQL Server 2008 server.
I used dtutil to import them to a directory. Is there any way I can
add all files from this directory to a SSIS project without clicking
'Add project' 100 times.

Windows Service not showing up when installed with Setup project


I have just installed a windows service, using a setup project but i can't find my service to start it. I did set the primary output, and i also did add custom actions. However, I still do not see my service listed...if i try to reinstall, it gives me the options to either repair or uninstall...which tell me that it is on the machine. Does anyone have an idea on how I can rectify this?

Please help....

VWD 2008 Not showing Last Project Open


Can anyone tell me why Visual Studio is not showing the last project open.  Actually it's not showing any that I have had open.  If there a clitch.


Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.
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