Forum Replies Created

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

December 19, 2013 at 3:16 am

#1674748

  • 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...

    December 19, 2013 at 12:00 am

    #1674710

  • 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...

    December 18, 2013 at 3:07 am

    #1674321

  • 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?

    December 18, 2013 at 2:53 am

    #1674315

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

    Sounds like you need an asynchronous script component.

    December 18, 2013 at 2:51 am

    #1674314

  • 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...

    December 16, 2013 at 3:21 am

    #1673612

  • 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...

    December 16, 2013 at 2:08 am

    #1673599

  • 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...

    December 15, 2013 at 10:32 pm

    #1673572

  • 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?

    December 13, 2013 at 4:14 am

    #1673205

  • 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...

    December 11, 2013 at 11:08 pm

    #1672828

  • 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...

    December 11, 2013 at 8:01 am

    #1672643

  • RE: Unable to access SQL Server instance alias as connection manager

    You're puzzling me a bit with all this talk of aliases.

    Why not just use standard connection managers and configurations / environments to control what points to what?

    December 11, 2013 at 12:28 am

    #1672513

  • RE: drop and create INDEX in ETL

    abhas (12/10/2013)

    Thanks Phil,

    But there is no Primary key in the target table , so can go with non-clustered index or clustered index?

    Thanks

    Abhas.

    Why does the absence of a PK have any...

    December 10, 2013 at 12:59 am

    #1672221

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