Forum Replies Created

Viewing 15 posts - 16 through 30 (of 668 total)

December 17, 2013 at 12:27 am

#1673963

  • RE: Open Source BI(Business Intelligence)

    Andrew G (12/16/2013)

    Have a look for open source BI projects like Pentaho, http://en.wikipedia.org/wiki/Pentaho

    Open source just means the software is free to use and modify.

    The software is free to use in...

    December 17, 2013 at 12:20 am

    #1673957

  • RE: Unzip .gz file from network map drive and load into table (SQL 2012)

    If I understand correct, read the file name using a script task and assign the name to a variable.

    Follow this: http://stackoverflow.com/questions/5152671/how-to-load-an-xml-file-into-a-database-using-an-ssis-package

    November 29, 2013 at 12:43 am

    #1669766

  • RE: MSBI career

    Markets always welcome good skills both personal and technical. It's upto you to decide. When you say you are good you can measure how many issues you have resolved for...

    November 29, 2013 at 12:37 am

    #1669764

  • RE: SSIS - Remove unused variables and such from SSIS ?

    What variables are you talking about? You can delete the SSIS variables you do not require for package execution from the designer by edit the dtsx file

    November 7, 2013 at 2:21 am

    #1664677

  • RE: OLE DB Error Redirect - Generic Error Descriptions

    Shout out loud if you need any further info!

    November 7, 2013 at 2:17 am

    #1664676

  • RE: OLE DB Error Redirect - Generic Error Descriptions

    Also, you can design error handling like this:

    http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/04/08/ssis-design-pattern-custom-error-handling.aspx

    November 7, 2013 at 12:29 am

    #1664643

  • RE: OLE DB Error Redirect - Generic Error Descriptions

    Hi Doshan, have you checked this link

    If custom error message(s) is the ultimate requirement, in that case you will have to design a custom component with all sorts TRY...CATCH blocks...

    November 7, 2013 at 12:10 am

    #1664634

  • RE: SSIS Script task with C# Help

    Ravikptel (10/29/2013)

    which check if file open while archiving. it will catch that file and throw a log in ssis

    Can you re-phrase this text. What is it that you want...

    November 6, 2013 at 11:54 pm

    #1664633

  • RE: Convert SSIS datetime to sql server 2005 datetime ?

    Do you know what is SSIS variables and are you comfortable with Execute SQL Task in SSIS?

    October 29, 2013 at 3:03 am

    #1662246

  • RE: SSIS Error: The binary code for the script is not found

    See this:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6665928e-c3fe-46f9-a426-1e9721ef61f6/ssis-2008-the-binary-code-for-the-script-is-not-found?forum=sqlintegrationservices

    http://stackoverflow.com/questions/16329138/where-can-i-find-the-ssis-precompile-property-for-script-tasks-in-sql-server-200

    October 29, 2013 at 1:42 am

    #1662222

    • Viewing 15 posts - 16 through 30 (of 668 total)