Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 13,879 total)

  • RE: Skip Header Rows in Excel and Concatenate Excel column names in SSIS

    chaseurpuli (12/18/2013)


    Phil Parkin (12/18/2013)


    Phil Parkin (12/18/2013)


    Sounds like you need an asynchronous script component.

    But why do you care what the column name is?

    Thanks for your reply Phil. Unfortunately, the destination table...


  • RE: Skip Header Rows in Excel and Concatenate Excel column names in SSIS

    Koen Verbeeck (12/18/2013)


    Phil Parkin (12/18/2013)


    Phil Parkin (12/18/2013)


    Sounds like you need an asynchronous script component.

    But why do you care what the column name is?

    Are you talking to yourself now? 🙂

    I get...


  • RE: Skip Header Rows in Excel and Concatenate Excel column names in SSIS

    Phil Parkin (12/18/2013)


    Sounds like you need an asynchronous script component.

    But why do you care what the column name is?


  • RE: Skip Header Rows in Excel and Concatenate Excel column names in SSIS

    Sounds like you need an asynchronous script component.


  • RE: ssis for each loop into files help

    SQL_Kills (12/16/2013)


    I've worked it out now, so I don't need help on how to do this.

    Well done. I have some ideas about how I would do it and will post...


  • RE: ssis for each loop into files help

    SQL_Kills (12/16/2013)


    1. I need to create a ssis package

    2. I want it to query the orders table for each orderid then for each result set it returns for each orderid...


  • RE: ssis for each loop into files help

    For each OrderNo I want to create a Text File into my C: Drive Folder, so the file name will look something like this "C:\A1000.txt" with each text file having...


  • RE: For Each Loop Variable Causing Package to Fail

    Is there a chance that anyone (or even you) has one of the files open in Excel?


  • RE: bulk insert operation through SSIS package.

    arooj300 (12/11/2013)


    Thanks for the reply...

    I want to clear my question , I think this will be easy to understand.

    we have a production DB. we have millions of data which client...


  • RE: bulk insert operation through SSIS package.

    Koen Verbeeck (12/11/2013)


    I think it is quite normal that readers are blocked when a bulk insert operation is going on. This is to prevent dirty reads.

    +1 agreed this is sensible...


  • Viewing 15 posts - 9,481 through 9,495 (of 13,879 total)