Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,047 total)

  • RE: Pass parameter while executing SSIS

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables...

    December 19, 2013 at 2:47 am

    #1674745

  • RE: Pass parameter while executing SSIS

    Evil Kraig F (12/19/2013)

    Two ways come to mind. Configuration for the variables, or run time settings when you call the SSIS executable via the command line. If you...

    December 19, 2013 at 2:14 am

    #1674735

  • RE: Pass parameter while executing SSIS

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself...

    December 19, 2013 at 2:13 am

    #1674734

  • RE: Data Transfer through SSIS

    Thanks a lot guys.. It worked :-):-D

    December 18, 2013 at 5:54 am

    #1674376

  • RE: Data Transfer through SSIS

    Koen Verbeeck (12/18/2013)

    kapil_kk (12/18/2013)

    After data gets transferred change the status flag to 1 for those rows...

    In which table? Table1 or table2?

    in table1 from which I am transferring data..

    December 18, 2013 at 5:25 am

    #1674364

  • RE: Data Transfer through SSIS

    Koen Verbeeck (12/18/2013)

    kapil_kk (12/18/2013)

    Abu Dina (12/18/2013)

    +1 to Koens's suggestion.

    I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success...

    December 18, 2013 at 5:20 am

    #1674361

  • RE: Data Transfer through SSIS

    Abu Dina (12/18/2013)

    +1 to Koens's suggestion.

    I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success precedence constraint) that...

    December 18, 2013 at 5:07 am

    #1674355

  • RE: Data Transfer through SSIS

    Koen Verbeeck (12/18/2013)

    kapil_kk (12/18/2013)

    Abu Dina (12/18/2013)

    If your source data comes from a SQL Server table then why not use SQL command as your Data Access mode (in the OLEDB Data...

    December 18, 2013 at 5:03 am

    #1674351

  • RE: Data Transfer through SSIS

    Abu Dina (12/18/2013)

    If your source data comes from a SQL Server table then why not use SQL command as your Data Access mode (in the OLEDB Data Source component) and...

    December 18, 2013 at 4:48 am

    #1674339

  • RE: Performance Opinion

    Jeff Moden (12/14/2013)

    @kapil_kk,

    I don't see any obvious severe problems in the code. I agree with Gail, though. One test is worth a thousand expert opinions. Run the...

    December 15, 2013 at 2:31 am

    #1673514

  • RE: Performance Opinion

    ScottPletcher (12/13/2013)

    I suggest making index changes scripted below, following these steps:

    1) Capture and save the existing index missing/usage stats for that table immediately, before any hanges are made.

    2) Run the...

    December 14, 2013 at 12:48 am

    #1673459

  • RE: Performance Opinion

    ScottPletcher (12/12/2013)

    1) Maybe you can combine the three separate UPDATEs into one, as shown below, avoiding repeated joins of the same tables.

    2) Depending on the row counts, you might consider...

    December 12, 2013 at 11:37 pm

    #1673163

  • RE: Performance Opinion

    dwain.c (12/12/2013)

    You should wrap your UPDATEs/INSERT/MERGE in a TRANSACTION and then do COMMIT/ROLLBACK consistent with your error handling.

    Thanks Dwain, I will do that 🙂

    December 12, 2013 at 11:20 pm

    #1673161

  • RE: Performance Opinion

    GilaMonster (12/11/2013)

    More nolock abuse. Are the users aware and happy with the fact that their reports could return incorrect data?

    Ok, I will remove that nolock part from code.......................

    Other than that...

    December 11, 2013 at 11:56 pm

    #1672833

  • RE: hat is wrong with this insert statement?

    Yes, It will work

    December 1, 2013 at 11:29 pm

    #1670005

Viewing 15 posts - 91 through 105 (of 1,047 total)