Forum Replies Created

Viewing 15 posts - 46 through 60 (of 1,118 total)

  • RE: data pump into MySQL

    The bulk-load API is not related to MySQL. It is ODBC-based API, which uses the low-level ODBC handles and functions. If you are C++ programmer, I'm talking about similar type...

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

  • RE: data pump into MySQL

    I disagree. It is included in the product so does not require a cash outlay.

    The solution you present requires extra cash outlay in the contractor pocket who is doing the...

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

  • RE: data pump into MySQL

    opc.three (6/29/2012)


    Here is an example for you. It requires no third party components and modification of only a few lines of VB.net code to get working with your chosen ODBC...

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

  • RE: data pump into MySQL

    opc.three (6/29/2012)


    With SSIS 2008/2012 it is easy using a builtin component, but with 2005, sadly, it is not. Check Pragmatic Works for a third party component. I think they have...

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

  • RE: SSIS 2005 package with mysql as destination

    Convince? No. Convincing is your job, not mine My job is to evaluate all options and present the one I think is best for the task at hand, for...

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

  • RE: SSIS 2005 package with mysql as destination

    It is up to YOU to convince your clients to use third-party components when helpful/needed. Using such functionality can actually optimize your development and reduce the total cost for your...

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

  • RE: SSIS 2005 package with mysql as destination

    Interesting article. I agree VB6 is a great solution. And that's why I said there is no newer version. VB.NET we both agree is a different beast.

    Regarding COZYROC's components, it...

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

  • RE: SSIS 2005 package with mysql as destination

    Oh, boy. Saying VB.NET is the new version of VB6 is like saying VB Script is VB6-light. VB.NET is very different language and comparing to VB6 or even implying they...

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

  • RE: SSIS 2005 package with mysql as destination

    Is the ODBC CozyRoc Destination supported by MySQL or Microsoft?

    No, it's not. But you see someone from COZYROC posting here to this person's question, right? I don't see anyone from...

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

  • RE: SSIS 2005 package with mysql as destination

    opc.three (6/28/2012)


    CozyRoc (6/28/2012)


    I would recommend you don't waste time looking at OLEDB MySQL drivers.

    Why not? Do you know of anything wrong with this one? MySQL OLE DB Provider

    Use with DTS/SSIS

    -...

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

  • RE: SSIS 2005 package with mysql as destination

    subhashmarti (6/27/2012)


    Hi All,

    Can you please tell me if any one has done an ssis package with MYSQL as destination,

    sql is the source and mysql is the destination, what destination can...

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

  • RE: Foreach iteration delay

    The approach with a script will work good.

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

  • RE: How Can I Update Data From An Email Attachment ?

    clucasi (6/11/2012)


    I need to update SQL 2005 from an email attachment, which is a delimited Excel 2010 file. The same named file is delivered to me with updated data throughout...

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

  • RE: Upload a file to HTTPS Website from SSIS

    praneethus (6/5/2012)


    Hello Friends,

    I am facing trouble to upload a file to HTTPS Website, Can you please provide me the process to achieve the same with SSIS. Please do the...

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

  • RE: Excel file connection nit getting closed in Foreach ADO.NET Schema Rowset Enumerator

    ram11sql (5/21/2012)


    Hi

    I am using "Foreach ADO.NET Schema Rowset Enumerator" to get sheet names, but excel file connection is not getting closed after the loop is completed. How to...

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

Viewing 15 posts - 46 through 60 (of 1,118 total)