Forum Replies Created

Viewing 15 posts - 151 through 165 (of 1,118 total)

  • RE: SSIS pulling data from SAS

    CozyRoc have just released new adapters for reading/writing SAS's sas7bdat files. These are the relevant components:

    CozyRoc SAS Data Source - for reading sas7bdat files.

    CozyRoc SAS Data Destination - for reading...

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

  • RE: SSIS/SSRS connection to Intersystems Cache

    sgs-930137 (4/27/2011)


    I'm looking for any pointers on accessing VMS data that is overlaid with CACHE. I'd like to use SSRS for reporting. I've found a couple of articles...

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

  • RE: Compiled .Net code in SSIS task poor insert performance

    Steve Newton (4/21/2011)


    Thanks for the replies. This is agency data which enriches and corrects our dataset which is why we run over the top of all records each month.

    The...

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

  • RE: Deleting data from Excel File

    bhavika.chauhan (4/20/2011)


    Can i delete data from excel file , after i have copied the file into another folder using SSIS (File SystemTask)

    The standard Excel adapters doesn't support data deletion. Using...

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

  • RE: Compiled .Net code in SSIS task poor insert performance

    The web service is DEFINITELY the issue. How many records are hosted in your web service? Is it possible to load data from it in bulk ? Instead of asking...

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

  • RE: Salesforce attachments stored as binary data needs to be rendered viewable.... help!

    The code to convert base64 to binary is one line:

    Dim result() As Byte = Convert.FromBase64String( base64str )

    If you are indeed SSIS developer, I would recommend you get a good book...

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

  • RE: search and replace SSIS package

    yosiasz (4/14/2011)


    I load them programmatically or by editing the config file?

    You can load them from the config file.

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

  • RE: search and replace SSIS package

    yosiasz (4/14/2011)


    I have one parent table with multiple packages wrapped in sequence containers. the packages in the sequence containers have variables and connections that need to be changed as they...

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

  • RE: UPdating Sharepoint list from ssis

    sri.gads (4/14/2011)


    Yeah, but this do not contain any work around sample. I would like to have work around or do a small sample for practice. i.e to update a sharepoint...

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

  • RE: UPdating Sharepoint list from ssis

    sri.gads (4/14/2011)


    I am using VS 2005, i would like to update the sharepoint list based on the update that is done in oracle.

    Can you please let me know any work...

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

  • RE: UPdating Sharepoint list from ssis

    sri.gads (4/13/2011)


    hi can any one let me know some inputs on how to update share point list from ssis. i have searched many blogs and forums but could not find...

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

  • RE: search and replace SSIS package

    yosiasz (4/12/2011)


    Greetings

    I have an SSIS package with Sequence containers that call other SSIS packages. How can I change values in the whole package including "sub-packages" via a script that uses...

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

  • RE: ODBC LookUp Transformation SSIS 2005

    Hi,

    There is no such update for SQL 2005 and don't expect one any time soon. You have three options:

    1. Upgrade to SQL 2008.

    2. Implement:

    - Loading of ODBC lookup information into...

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

  • RE: Script Task referencing its own properties

    Craig,

    The properties you are referring to are contained in the so called "script host", which is the actual custom component managing the script object. My question is why would you...

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

  • RE: Odd formatting in Excel from SSIS

    If you can use third-party solutions, check the commercial CozyRoc Excel Destination Plus. It is completely independent from the old MS JET driver on which the standard SSIS component is...

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

Viewing 15 posts - 151 through 165 (of 1,118 total)