Forum Replies Created

Viewing 15 posts - 646 through 660 (of 1,118 total)

  • RE: dynamic change of flat file mappings

    John Rowan (8/10/2009)


    It may just mean that my definition of 'easy' differs from yours. My post previous to your request that I try your product and provide you with...

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

  • RE: dynamic change of flat file mappings

    John Rowan (8/10/2009)


    That's great. I'm sure it works just fine, but the fact is that this problem is easily solved with tools and techniques already built into SSIS and...

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

  • RE: dynamic change of flat file mappings

    John Rowan (8/7/2009)


    Dynamically building out the BCP command and calling it from SSIS is as good an option as any. Any other way you go, you get bound to...

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

  • RE: dynamic change of flat file mappings

    Paul_J (8/6/2009)


    Have you considered using BCP? That is a great tool. You can call it from within an SSIS package for each of your source files if required.

    How are you...

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

  • RE: dynamic change of flat file mappings

    Gkhadka (8/6/2009)


    CozyRow,

    I have no doubts that indeed it is a great tool. and i always wished that my company ( or any place i have been or will be) allow...

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

  • RE: dynamic change of flat file mappings

    Gkhadka,

    You will be amazed how many big companies are CozyRoc SSIS+ customers. We are quickly establishing as the go-to-provider for third-party SSIS components and technology. The CozyRoc components are saving...

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

  • RE: dynamic change of flat file mappings

    Check CozyRoc Data Flow Task Plus. It includes support for dynamic data flows and may help in your scenario. We will be glad to hear your feedback.

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

  • RE: adding extra columns to a CSV file cause SSIS import to fail

    ryan.lawrence (6/10/2009)


    we import over 200 flat files daily into a sql server 2005 database using SSIS. When we were in SQL 2000 using DTS we could add any new...

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

  • RE: Looking for SSIS scalable solution

    CozyRoc has enhanced Data Flow Task Plus to support dynamic data flows. We will be happy to hear your feedback.

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

  • RE: SSIS 2005 - Skip first few rows from excel sheet & Import Data to SQL DB

    You have to setup an Excel Connection and then use similar SQL statement to the one you use with the cells range. It should work, but keep in mind you...

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

  • RE: Import multiple csv files to multiple sql tables

    Suhel,

    We have just released beta with an enhancement, which might help. We have improved the CozyRoc Data Flow Task Plus to support dynamic data flows. We will be happy to...

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

  • RE: Convert SQL data or Flat File or Csv File to XML ?

    Harry (5/3/2009)


    Hi Experts,

    I am new to SQL Server , i was practicing some...

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

  • RE: Insert,Update,Delete in SSIS - newbit in SSIS

    Check the comments below after the post. One of the approaches mentioned is this:

    "Use the OLE DB Command to do the updates, an OLE DB Destination to do the inserts."

    --

    It...

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

  • RE: Insert,Update,Delete in SSIS - newbit in SSIS

    Patrick.I (8/3/2009)


    I'm using OLEDB Desitnation to insert some data from a csv file.

    But i'm receiving files and i need to check if the record exist update the record and if...

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

  • RE: Referencing variables in a Script Task

    trudye10 (8/4/2009)


    I am writing a .NET script to email end-of-job notice to my users. In that eoj notice I have to include how many records came from each user. Because...

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

Viewing 15 posts - 646 through 660 (of 1,118 total)