Forum Replies Created

Viewing 15 posts - 9,451 through 9,465 (of 13,880 total)

  • RE: Want to update the table performance vice which transformation is best to use

    Inserts are best done using a dataflow.

    Updates are best done as a set-based operation - meaning that the OLEDB command is NOT the way to go. One possibility is funneling...

    January 10, 2014 at 1:40 am

    #1679058

  • RE: Want to update the table performance vice which transformation is best to use

    sharmili.net (1/10/2014)

    Hi Everyone,

    I want to update the table in a database, performance vice which transformation is best to use?

    Thanks in advance.

    sharmi

    "Vice"? What is that?

    January 10, 2014 at 1:10 am

    #1679051

  • RE: Data Flow Transformation Performance Issue

    harsimranjeetsinghwasson (1/9/2014)

    I have a store procedure that is source for creation of my CSV, it take one minute to execute to 100000 records

    and this result set is used to preparing...

    January 10, 2014 at 12:24 am

    #1679046

  • RE: Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

    What would the SSIS Syntax and could you tell me in a little more detail the steps that I take to accomplish this if not too much trouble?

    Can you expand...

    January 10, 2014 at 12:20 am

    #1679045

  • RE: Holiday table

    dwain.c (1/8/2014)

    Phil Parkin (1/8/2014)

    A few tasty techniques in that function Dwain. I have a quick follow-up question for you: as the function does not reference any external tables or views,...

    January 9, 2014 at 12:47 am

    #1678685

  • RE: Holiday table

    A few tasty techniques in that function Dwain. I have a quick follow-up question for you: as the function does not reference any external tables or views, does 'WITH SCHEMABINDING'...

    January 8, 2014 at 10:59 pm

    #1678673

  • RE: Flat File connection not fixed width but the row length is !!

    Luis Cazares (1/8/2014)

    What about importing last column as a string and using a derived column to validate and convert value into int?

    +1 that's what I'd do too.

    January 8, 2014 at 10:31 am

    #1678496

  • RE: Holiday table

    DaveDB (1/7/2014)

    Hi Phil,

    Thanks for the tip. Didn't even notice the apostrophes 🙂

    No problem. My colleagues love the fact that I'm an amateur proofreader as well as a SQL Server professional:w00t:

    And...

    January 7, 2014 at 12:45 pm

    #1678209

  • RE: Holiday table

    DaveDB (1/7/2014)

    Hello and happy new year!

    I wrote a stored proc that basically aggregates some data based on how many Monday's, Tuesday's, Wednesday's etc in a current month (date range parameters)....

    January 7, 2014 at 12:34 pm

    #1678205

  • RE: How to tell if your code is executing inside sp_ExecuteSQL?

    I can't see any way of doing this directly, without using an additional param.

    But logically, within your proc, can you assume that the nesting level can either:

    1) Remain the same

    2)...

    January 7, 2014 at 12:22 am

    #1677973

  • RE: ssis import export wizard

    rswinehart (1/2/2014)

    You could use an expression to calculate the file name, if the naming is consistent.

    If you feel you cannot create a naming rule that would always work,...

    January 5, 2014 at 8:34 am

    #1677590

  • RE: SSIS switchboard/menu/dashboard ... ?

    There are some issues that you will face with this solution.

    Let's assume that you have the packages developed & deployed. You have 12 SQL Agent jobs created. You have built...

    January 5, 2014 at 8:32 am

    #1677589

  • RE: OLE DB source using variable to file output

    Sowbhari (1/3/2014)

    If you can change the stored procedure to output as a concatenated string of the required columns data delimited with "," for the respective customer then you can write...

    January 5, 2014 at 8:03 am

    #1677587

  • RE: SSIS 2008 R2

    veers.way (1/3/2014)

    Please Tell me if I am not clear

    You are not clear.

    What is MNC?

    What do you mean by 'real time'?

    Visual Studio (in the form of BIDS or SSDT) is the...

    January 5, 2014 at 7:54 am

    #1677586

  • RE: Stored Procedure Logging

    Ok. The workaround you found does not apply for 2012. Instead, please search for 'with result sets'

    Sorry but I'm not at my PC so cannot post something more detailed right...

    January 3, 2014 at 4:15 am

    #1677195

Viewing 15 posts - 9,451 through 9,465 (of 13,880 total)