.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

Custom SSIS project template vrs package templates

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
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.

View Complete Post

More Related Resource Links

Where is StartPage.cproj : Custom Start Page Project Template


I am reading through Wrox Professional Visual Studio 2010.
In Chapter 3, there is an example of how to customize and extend the start page.

So he wants you to copy the files from C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\StartPages\<Culture>
C:\Users\<user name>\Documents\Visual Studio 10\StartPages. He say you may need to create this because it may not exist by default. So I would just copy the files into:
C:\Documents and Settings\Sam\My Documents\Visual Studio 2010\StartPages and work from there right?

Then he says double click StartPage.csproj to opent the WPF project in Visual Studio 2010.
But StartPage.csproj simply does not exist anywhere.

I have installed Visual Studio 2010 sdk and the Custom Start Page Project which shows up in extension manager.
I just can't figure out how to use it.

I am on Windows XP.

Missing Custom Control Library Project Template in Visual C# 2010 Express?


I am using Microsoft Visual C# 2010 Express Version 10.0.30319.1 RTMRel and I want to add a Project for a WPF Custom Controls library. Note: The WPF Custom Control Item Template is included and can be added to a WPF Application project.

Does anyone know:

  1. Should the WPF Custom Control Library Template be part of this application edition?
  2. Where is the online documentation that states exactly which features are and are not included in each edition?
  3. What can be recomended as a work around?


How to Create a Custom Item Template and Project Template

When you're working on a web project, there are times you wish you could have captured all of the stuff you're working on often and then re-use it later on, similar to code snippet. For example, if you work with JaveScript, HTML5 a lot, you would want to be able to create a new web project that already has a predefined set of jQuery library, or add a new page that already has references to the new HTML5 doctype and the jQuery libary, so you don't have to constantly modify the page to add those in. You can achieve this by creating your own Item Template and Project Template. Recently, Rey Bango has posted a nice blog about this topic at How to Create HTML5 Website and Page Templates for Visual Studio 2010 . Joe Cartano also had a blog about it...(read more)

SSIS Project Templates Not Showing


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

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

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

can template save custom pages?


I created a template off a site I made last year (without content). That site had some custom pages with webparts on them.  These pages were linked to from the Quick Launch menu.  I just made a new site using that template and it appears the custom pages weren't part of the template as when I click on the links to them in the QL menu, I get a 404 page not found error. I tried again saving the template with content this time and my custom pages show up - but then I have all the lists/libraries filled with old content.  Any remedy?

I am on MOSS 2007 and can use Designer.

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Find and replacement SSIS Custom component issues

Hi All, I developed one custom component in SSIS  Find and Replacement I register the dll and copy and paste in to Pipleline component. but it's not visible in the Toolbox while choose Items Please suggest why it's not comming.. using   System; using   System.Collections.Generic; using   System.Linq; using   System.Text; using   Microsoft.SqlServer.Dts.Pipeline; using   Microsoft.SqlServer.Dts.Design; using   Microsoft.SqlServer.Dts.Runtime.Wrapper; using   Microsoft.SqlServer.Dts.Pipeline.Wrapper; using   System.Data.OleDb; using   System.Data.SqlClient; using   System.Windows.Forms; using   System.Runtime.InteropServices; using   System.Data; using   System.Collections; using   Microsoft.SqlServer.Dts.Runtime; using   Microsoft.SqlServer.Server; namespace   FindAndReplace { [ ComVisible(true)] [ DtsPipelineComponent ( DisplayName = "Find and Replace", Description = "Finding Find and replace", IconResource = "Microsoft.Samples.SqlServer.Dts.Find and Replace.ico", ComponentType = ComponentType.Transform )]   class FindAndReplace :PipelineComponent {   #region   ProvideComponentProperties   /// <summary>   /// </summary>   public ove

SSIS Package Transaction locks entire table

Hello, I have SSIS package that using transactions and working as expected. But this locks all the tables involved in the data flow that are get inserted/loaded. If I query those tables during package execution the query waits till SSIS releases the lock. But I can still query those tables using NOLOCK hint. Is this possible SSIS will lock only the rows that it insert/update/delete etc? So that other user can still use that table or another instance of same SSIS Package can load data into those tables? My Package: In the package level I have TransactionOption = Required. The Sequence (Data Flow is inside this sequence) TransactionOption = Supported. I had some issue in my package that I posted here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dfb5a8b9-d43c-452b-bb21-d6aea192fc97 and also resolved. Now I descovered this issue and trying to resolve. Thanks, Prabhat

Execute SSIS Package PART based on Some Condition

Hello, Is it possible to execute part of the Package based some condition? (Like If var1 = true, then execute this block). If Yes, what control flow I should use. Please advse. I will have a Package Variable and if that variable is True then some part should execute. REst all should execute every time the package is called. Like if I will have "2 Sequence Container" in my control flow, the first one should execute every time, but 2nd one only if the variable value = True. Thanks, Prabhat

SSIS package Scheduled Job Not Running

I'm not sure which way to research this issue.. I have an SSIS package that we can run just fine manually. But, when we put it into a scheduled job, it won't run. The package is on the same system as the SQL Server (2005), but it does call for updates from tables on another SQL Server (2000) on another domain (trusted). So, I'm thinking this might be a permissions / security issue, but not sure where to start... The package ProtectionLevel is "don't save sensitive", but that didn't help. Any help would be appreciated. Thanks. jill

How to make SSIS Package Fail when something goes wrong

Hello, Is there any way I can make the package (SSIS 2005) fail when something happen? Like: if some value become zero I will to make the package fail from with in the SSIS, so that the AgentJOB  that started this package will know? Thanks, Prabhat Nath

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

Can not get excel connection when calling an SSIS package from ASP

I have an SSIS package importing data from excel. I have coded it and deployed it on the sql 2008 server. I then execute it via a stored procedure with the following: select @cmd = 'C:\"Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /sq "HRIS"' select   @cmd = @cmd + ' /SET \Package.Variables[User::path].Properties[Value];"' + @path + '"' exec   @rtn = master..xp_cmdshell @cmd   This works fine when  i execute it on my local machine. But when I try to call this Stored proc from my asp app (classic asp, not .net) I get the error: Code: 0xC0202009 Source: HRIS Connection manager "SourceConnectionExcel" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error". End Error   Any help would be greatly apprecitated

Execute an SSIS package from ASP.net (C#) - my package keeps failing. Help! - Works on localhost but

I'm looking for any and all information on how to execute an SSIS package from my asp.net web site. I have written the call and when I run the application from (Localhost) it works, but when I run it from the server it does not.Here is my code to call and execute the package: public string ProcessFiles(int ClientID, string FileName) { //System.Security.Principal.WindowsImpersonationContext impersonationcontext; //impersonationcontext = ((System.Security.Principal.WindowsIdentity)ServiceContext.User.Identity).Impersonate(); string packagePath = "\\\\\\Customer File Import.dtsx"; Microsoft.SqlServer.Dts.Runtime.Application app; Microsoft.SqlServer.Dts.Runtime.Package pkg; Microsoft.SqlServer.Dts.Runtime.Variables vars; Application integrationServices = new Application(); DTSExecResult result; FileName = FileName.Substring(FileName.Length - 25 , 25); app = new Microsoft.SqlServer.Dts.Runtime.Application(); pkg = app.LoadPackage(packagePath, null); //pkg = integrationServices.LoadFromSqlServer("Customer File Import.dtsx", "", "healthtech\\brian.montfort", "Nightdragon8", null); vars = pkg.Variables; if (pkg.Variables.Contains("
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