Forum Replies Created

Viewing 15 posts - 31 through 45 (of 45 total)

  • RE: Help with placing condition - SQL Statement

    Thanks Phil .. I was googling just that! Thank you 🙂

  • RE: Help with placing condition - SQL Statement

    Hi Phil,

    Many thanks! Thank you I have learned a new way of thinking and looking at things when I saw your reply. I will try and replicate your query and...

  • RE: Help with placing condition - SQL Statement

    Apologies for not being clear .. it has been re-written..

    Source Data Structure:

    TABLE_A:

    IDRank2sysnoRank1

    108442181781

    108444275292

    10845122994

    10845322129

    1. I want to 'pivot' the data by having the one line for each ID value.

    2. New...

  • RE: SSIS Sequence Containers

    Thank you for your reply.both the source and the destination are sequel server database tables.

    The sequence containers are at present set to run in parallel, I am not sure how...

  • RE: SSIS - Script COmponent

    Hi Eliott,

    Many thanks for your reply

    I have a series of csv files where I need to

    1. search for a string say 'ZZZ' in column B.

    2. Copy a string from...

  • RE: SQL Code Help

    Thanks Jim, I will try out your code .. I had a basic CASE statement structure ..

  • RE: SQL Code Help

    Hi Sean,

    That's not an option as data will be copy pasted across from various data sources directly into the table.

  • RE: SQL Code Help

    HI Drew,

    can I have a join in a CASE statement?

  • RE: SQL Code Help

    Hi .. I have written it out with CASE statements but if I could sort out the one issue where the variable is going wrong then I could get the...

  • RE: SQL Code Help

    Thanks Drew, yes I need them in one column and I have too many columns to utilise the CASE statement. Going forward for a non-technical person to maintain it or...

  • RE: SQL Code Help

    Hi Jim,

    Many thanks for your help. I should have mentioned I have gone down the route of CASE statements .. but there are far too many columns to look up...

  • RE: SQL Code Help

    I have tried your code ... many thanks again .. it works great but it returns multiple rows with 'Error Messages'.

    For my purposes I would want to have the...

  • RE: SQL Code Help

    Hi Lowell,

    Many thanks for the code .. I am looking to loop as I will have a number of such columns and I will want to concatenate the error messages...

  • RE: Reuse SSIS package by Changing Variable Values

    First of all many thanks for your support on this.

    I have since tried to simplify my model as much as possible.

    I have 7 distinct individual folders, I have created...

  • RE: Reuse SSIS package by Changing Variable Values

    Hi Sam,

    Many thanks for your reply. The answers to your questions are as follows:

    1. Do you want to load a few files occasionally, or a large amount of files regularly?...

Viewing 15 posts - 31 through 45 (of 45 total)