Post reply

CozyRoc Task are not in the Toolbox

  • November 29, 2011 at 1:52 pm

    #146149

    I downloaded CozyRoc today so that I could evaluate however none of the CozyRoc Task are in the Toolbox.

    I tried both SQL Server 2005 and 2008.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • November 29, 2011 at 6:33 pm

    #1414407

    Follow these steps to include in your toolbox:

    * Open BIDS

    * Open any SSIS package

    * Open your Toolbox

    * Right-click with your mouse in it and select Choose Items… menu

    * Click on SSIS Control Flow Items tab in the dialog

    * Find out from the list which SSIS+ tasks you would like to use and select the checkbox next to it.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 9, 2011 at 6:10 am

    #1419252

    Hi,

    I'm missing something because when I attempt to Select new tasks there are no CozyRoc Task.

    Do I have to register as Trial?

    I tried entering Trial in the license box and I could not enter anything.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 6:17 am

    #1419258

    You don't need a license key to test and develop from Visual Studio (BIDS).

    Is your copy of SQL Server registered or it is evaluation? You will need registered copy to be able to deploy license key.

    Please search all your drives for CozyRoc.SSISPlus*.dll file. Make sure the file is deployed in the following locations:

    2005 32bit - Under "Program Files"

    * Microsoft SQL Server\90\DTS\Connections

    * Microsoft SQL Server\90\DTS\Tasks

    * Microsoft SQL Server\90\DTS\PipelineComponents

    * Microsoft SQL Server\90\SDK\Assemblies

    2005 64bit - Both "Program Files (x86)" and "Program Files"

    2008 32bit - Under "Program Files"

    * Microsoft SQL Server\100\DTS\Connections

    * Microsoft SQL Server\100\DTS\Tasks

    * Microsoft SQL Server\100\DTS\PipelineComponents

    * Microsoft SQL Server\100\SDK\Assemblies

    2008 64bit - Both "Program Files (x86)" and "Program Files"

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 9, 2011 at 6:24 am

    #1419263

    I found the files and the CozyRoc Task.

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 6:48 am

    #1419297

    I created a simple SSIS Package and specified the CozyRoc Excel Destination Plus Task but I get an error that it is an unknown connection type?:unsure:

    Error: 0xC0014005 at : The connection type "EXCEL+" specified for connection manager "Excel Connection Manager 1" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

    Error: 0xC0010018 at : Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts">

    <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>

    <DTS:Property DTS:Name="ObjectName">Excel Connection Manager 1</DTS:Property>

    <DTS:Property DTS:Name="DTSID">{D840793C-6116-47A" from node "DTS:ConnectionManager".

    Failed to load the package "Exception deserializing the package "The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.

    ".".

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 8:09 am

    #1419400

    I had to change the Debug Option 64bitRuntime to False and I no longer get the error.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 5:43 pm

    #1419670

    Did you use the 64bit installer for SSIS+ ? You have to use the 64bit installer for 64bit systems.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 23, 2012 at 11:11 pm

    #1437472

    I need a cozyroc copy for evaluation. SSIS script task plus.

    Please share any download link.

    My Email : johariqbal@gmail.com

  • January 24, 2012 at 4:55 am

    #1437581

    http://www.google.com - that should get you where you need to be 🙂

    _____________________________________________________________________
    Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply