Search Results: IntegrationServices

• 
  Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

  SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#.

  Author:  mafiswana     Date: 8/14/2012     Section: Article

  tags : CatalogFolder, Create SSIS Package, Managed Object Model, Microsoft Visual C# 2010, Microsoft.SqlServer.Dts.Runtime, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, SSDT, SSIS 2012, SSIS Catalog, Visual Studio 2010
• 
  SSIS with XLSM excel sheet as source

  I need to use a .xlsm (excel with macro) sheet as my source for updating data to our database. I tried following these articles to do it correctly as you need to use OleDB source (not an excel source) for an xlsm file: 1) http://social.msdn.microsoft.com/

  Author:  sherz1000     Date: 9/6/2011     Section: Forum
• 
  event id 12291

  maclean, From what I found on google ( http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/b203daa3-cafc-4df9-9712-a8724b8aa910 ) this is looking like a drive reference that isn't available to either your account or the agent accou

  Author:  KeithHyer     Date: 8/17/2011     Section: Forum

  tags : execute process, permissions
• 
  Looking for Reference for EDI Using SSIS and X12 Format Files

  I don't have any experience myslef but I did find this on MSDN: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7b99efef-288d-4ab9-885d-367a818b38bb .

  Author:  MikeDavis     Date: 8/19/2010     Section: Forum

  tags : EDI, x12, ssis
• 
  LINQ in SSIS packages - ( a small list of links )

  keerti posted a question on my wall asking if I could provide any links to aide in the understanding of using LINQ from an SSIS package. As it happens, I'm actually not familiar with much about LINQ - but I'll take any opportunity to learn something new -

  Author:  KeithHyer     Date: 12/15/2011     Section: Blog

  tags : component, SSIS. LINQ
• 
  execute sql task with precedence constraint

  Hi Daniel ,thanks for your quick response. for more information i posted in ; http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5a4ccc3d-f6b6-4933-947a-ec932052c272 http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationserv

  Author:  karteek     Date: 4/30/2012     Section: Forum
• 
  execute sql task with precedence constraint

  Hi Daniel ,thanks for your response. for more information i posted in ; http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5a4ccc3d-f6b6-4933-947a-ec932052c272 http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/t

  Author:  karteek     Date: 5/2/2012     Section: Forum

  tags : execute sql task with precedence constraint
• 
  SSIS Clarification: Loading Data from db to Excel

  It looks like column widths are limited to 255 characters in Excel: Correction, looks like you can have 32,767 characters in an Excel cell http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx Take a look at this fo

  Author:  sqlchicken     Date: 7/15/2011     Section: Forum

  tags : SSIS, excel
• 
  Unable to Edit Package Variable Value in SSDT at Design Time

  never mind I have got the solution - http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fd0677d8-109a-4d1c-9459-125a57c07b11

  Author:  mafiswana     Date: 7/6/2012     Section: Forum
• 
  Run SSIS via EXE

  Here is a thread from the MS forums that talks about this: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fe0110ec-bd8b-48aa-ab42-6e5706d71cbe

  Author:  KathiKellenberger     Date: 10/9/2012     Section: Forum
• 
  How to remove HTML formatting using SSIS components

  There were two different solutions that were discussed for this question in MSDN forum. http://social.msdn.microsoft.com/Forums/eu/sqlintegrationservices/thread/375f1c51-5f94-42f6-ac42-40651f088963 Please apply them and let us know the results

  Author:  vksingh24     Date: 11/5/2012     Section: Forum
• 
  How to remove HTML formatting using SSIS components

  Please follow the thread and link to fix the <HTML> tag issues http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/375f1c51-5f94-42f6-ac42-40651f088963/#7a855dba-328f-4e32-b116-91ce90197e1f

  Author:  jampa.sb     Date: 11/5/2012     Section: Forum
• 
  how to run ssis package on different servers at a time

  Hi Everyone, in my package we are applying lot of synchronous and asynchronous tranformations this is consuming lot of time to migrate.so, for this can we run package simultaniously on different servers , we are doing Full Migration i.e, one time process.

  Author:  karteek     Date: 2/8/2013     Section: Forum
• 
  SSIS Oracle

  Question that comes up fairly often is about connecting to Oracle. Here is a wiki entry we wrote about doing it in a 32 bit/64bit environment Here it is verbatim: Best Article found so far http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post

  Author:  MarkGStacey     Date: 8/23/2010     Section: Blog

  tags : Oracle drivers
• 
  Problem with Dynamic Excel Destination

  I am trying to create a dynamic excel destination using the answer provided here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/bda433aa-c8f8-47c9-9e56-efd20b8354ac/ I am following the same exact steps.. my SQL task is creati

  Author:  rockstar283     Date: 2/8/2012     Section: Forum
• 
  SSIS 2012: Programmatically Create Catalog

  This article uses a Script Task in SQL Server Data Tools to demonstrate creating a catalog and catalog folder.

  Author:  mafiswana     Date: 7/18/2012     Section: Article

  tags : C#, C# programming language, Catalog, CatalogFolder, IntegrationServices, Managed Object Model, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, script task, SMO, SMO Server, SQL Server 2012, SQL Server Integration Services, SSIS, SSIS 2012, Visual Studio 2010
• 
  View hangs OLE DB Src Editor -- Normal?

  This is normal and a known issue. See: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/e0191312-1de6-4735-a885-dc0134c7f062/ Even more specifics: http://consultingblogs.emc.com/jamiethomson/archive/2006/02/21/SSIS_3A00_-SELECT-

  Author:  moriente     Date: 12/1/2009     Section: Forum
• 
  Using OHS to extract data from SAP BW

  Sounds like you need to get some clarification on those requirements. Either way, check this thread over at MSDN forums. Looks like the answer given by MS guy might be what you're looking for: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationse

  Author:  sqlchicken     Date: 5/6/2011     Section: Forum
• 
  oledb source error

  Take a look at this post and see if it helps: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d1407b33-ec1f-45e3-ba58-c4cabdbc04ae/

  Author:  KathiKellenberger     Date: 11/16/2012     Section: Forum
• 
  Script Transformation Problem

  Have a look at the following...seems like there might be some issues if you installed SQL 2008 on the same machine. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b4e6ef94-40ef-4c96-b4e7-e91f7dfca690/

  Author:  MartinSchoombee     Date: 8/5/2011     Section: Forum
• 
  How is TFIDF Calculated in The Term Extraction Transformation?

  Hi Cloris To answer your question about logs: people using data mining should assume the natural log, not the base 10 or any other base log. Mathematically, the base you use does not matter in transformational space, but it will matter for a specific calc

  Author:  marktab     Date: 1/24/2011     Section: Forum
• 
  SSIS - "Microsoft.Jet.OLEDB.4.0" has not been registered." error in 64 bit machine

  Have you seen this post? http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/7f43a748-18a0-4201-a23e-671dc58e20ef

  Author:  m3crast     Date: 3/2/2011     Section: Forum
• 
  deployment package

  Please refer this forum... http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7c819700-a663-488f-8937-c236f43b42f5/

  Author:  meganathank     Date: 9/4/2012     Section: Forum
• 
  SSIS 2008 For Each Column in a Data flow

  Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here . Well things have changed since I wrote that blog, in fact I believe that old  code only works in SSIS 2005. So I thought I would be good to up

  Author:  MikeDavis     Date: 9/29/2011     Section: Blog
• 
  SSIS package error upon opening

  Hi Wasay, Try and run a repair on VS2008. or deleting the folder at this location: " C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8 ". It's generally advisable when your installing a preview of a new product (VS11, SQL2012, etc) to inst

  Author:  ChrisSchmidt     Date: 9/20/2012     Section: Forum