How does one code a Data Transormation Services project in Visual Studio?

All Replies

• Wednesday, February 06, 2013 3:30 AM

   

   
  

  0
  That is an integration services package. You edit it in Visual Studio, but you need Business Intelligence Development Studio installed for the equivalent version that the package was created

  ---

  Craig Bryden - Please mark correct and/or helpful answers

  • Reply
  • Quote

   
• Wednesday, February 06, 2013 4:29 AM

   

   
  

  0

  This is an integration package.

  You can debug as mentioned in the link and also make sure all the tasks (each component show here is a task) has delay validation property set to true

  http://beyondrelational.com/modules/12/tutorials/24/tutorials/9086/getting-started-with-ssis-part-9-debugging-ssis-packages.aspx

  Script task debudding:

  http://sqlserverpedia.com/wiki/SSIS_-_Script_Debugging

  http://geekswithblogs.net/darrengosbell/archive/2009/03/29/debugging-ssis-scripttasks-and-scriptcomponents-with-information-messages.aspx

  Regards,Eshwar.

  ---

  Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

  
  

  • Edited by Eswararao C Wednesday, February 06, 2013 4:31 AM
  •  
  • Reply
  • Quote

   
• Wednesday, February 06, 2013 9:27 PM

   

   
  

  0

  This link

  http://beyondrelational.com/modules/12/tutorials/24/tutorials/9086/getting-started-with-ssis-part-9-debugging-ssis-packages.aspx

  suggests I look at the progress tab for information.  So let's discuss the error.  The first thing that looks like a problem is this:

  • [Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred.
    Error code: 0x80040E09. An OLE DB record is available.  Source: "Microsoft SQL Native Client" 
    Hresult: 0x80040E09  Description: "The EXECUTE permission was denied on the object
    'sp_dts_addlogentry', database 'SSIS_Logs', schema 'dbo'.".

  I have permissions to the SSIS_Logs database. 

  When I looked for the stored procedure, sp_dts_addlogentry, I did not find it.  Is it supposed to be in Programmability -> Stored Procedures?

  What can i do? 

  • Reply
  • Quote

   
• Wednesday, February 06, 2013 9:30 PM

  Moderator

   

   
  

  0

  Bobby,

  I do not think the avatar image you used is appropriate, please change it right away please or I will suspend your account.

  ---

  Arthur My Blog
  

  
  

  • Edited by ArthurZMVP, Moderator Wednesday, February 06, 2013 9:30 PM
  •  
  • Reply
  • Quote

   
• Wednesday, February 06, 2013 11:02 PM

   

   
  

  0

  It is different now

  http://social.msdn.microsoft.com/Profile/Bobby%20Lawrence

  not reflected here because of browser queue issues.

  I found and ran the business intelligence app

  http://i67.photobucket.com/albums/h292/Athono/thereyouare_zpsafe6cbce.png

  and things ran a little further but I would still like to be able to look at the actual code.  Instead, I am left to try to find stored procedures that cannot be found and database tables that I have permissions to although the errors say I do not etc.

  Isn't there a way to examine this in code as if it were a C# program?

  • Reply
  • Quote

   
• Friday, February 08, 2013 1:43 AM

  Moderator

   

   
  

  0

  What kind of project is this?

  http://i67.photobucket.com/albums/h292/Athono/Capture_zpsa6604547.png

  Also, how do I debug such a project?

  I do not see where I can change the scripts that appear during a crash

  http://i67.photobucket.com/albums/h292/Athono/wholepage_zps184c2ca8.png

  
  

  This is a SSIS 2008 project.
  Go to the Event Handlers tab, you must see a Script Task that sends emails on the event of an error.
  

  ---

  Arthur My Blog
  

  • Reply
  • Quote

   
• Friday, February 08, 2013 10:35 PM

   

   
  

  0

  The tab, "Event Handlers" does lead to me to see a lot of script.  Thank you for showing me this.

  But it does not show me everything. 

  There are executables that do not have any event handlers:

  http://i67.photobucket.com/albums/h292/Athono/Capture-1_zps399e0158.png

  And these executables are real and have real associated code.  I know this because their results are listed in the "Progress" tab. 

  Where can I find this source code?

  
  

  • Edited by Bobby Lawrence Saturday, February 09, 2013 12:52 AM
  • Edited by Bobby Lawrence Saturday, February 09, 2013 12:53 AM
  •  
  • Reply
  • Quote

   
• Saturday, February 09, 2013 1:02 AM

  Moderator

   

   
  

  0

  Expand the Event Handlers folder (click on the + sign).

  But you really should be looking in:

  

  ---

  Arthur My Blog
  

  • Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, February 14, 2013 3:06 AM
  •  
  • Reply
  • Quote