Forum Replies Created

Viewing 15 posts - 361 through 375 (of 544 total)

  • RE: How to use row number in excel source?

    Koen Verbeeck (3/14/2012)


    Excel does not support the entire TSQL syntax.

    If the number of rows isn't that big you can use the SORT component to delete the duplicates for you.

    If performance...

  • RE: How to use row number in excel source?

    Sean Lange (3/13/2012)


    Wow you really are frantic today. Slow down and ask your questions with enough details so somebody else can help you.

    I am really sorry Sean...

    with cte as (select...

  • RE: finding duplicate records?

    Eugene Elutin (3/12/2012)


    366 points! You are not first-timer here.

    Please try to post your question as per "forum etiquette", link at the bottom of my signature.

    sorry about that..i was in...

  • RE: single quotes problem?

    I am sorry..yes, this is a poor architecture, not poor design .....

    the good thing is end user never going to touch this....

    only by myself...

    I did not understand the customer database...

  • RE: single quotes problem?

    Charmer (3/12/2012)


    But the thing is i did not create the stored procedure...

    it was previously created by some one....Now i changed it as you guys told that there would be some...

  • RE: single quotes problem?

    But the thing is i did not create the stored procedure...

    it was previously created by some one....Now i changed it as you guys told that there would be some injection...

    Thank...

  • RE: single quotes problem?

    Sean Lange (3/12/2012)


    I have to agree with Jessie here....WHY are you passing sql as a parameter???? I am going to take a guess that you will now execute the sql...

  • RE: single quotes problem?

    MyDoggieJessie (3/12/2012)


    Let me get this straight, you're passing in the entire SELECT statement as a parameter?

    If that's the case, check the length for your datatype on the parameter for the...

  • RE: Issue with SCD Component

    There is an another one called Cozy Rock's Table difference..it is good in performance wise. but need to add the update statement by our self...

  • RE: Importing data using a FOREACH loop

    ron.grace (2/21/2012)


    I'm trying to automate the import of a number of flat files in to a SQL database. Searching on the web I came a cross the FOREACH loop, but...

  • RE: Errors not being ignored

    Koen Verbeeck (2/21/2012)


    You should check for NULL values in the dataflow or at the source before you write them to a destination. Relying on the Ignore Failure of SSIS is...

  • RE: Errors not being ignored

    Koen Verbeeck (2/21/2012)


    Charmer (2/21/2012)


    Phil Parkin (2/21/2012)


    Charmer (2/21/2012)


    If Ignore Failure does not work exactly....then why should we have a such condition...or when will it work if we do Ignore Failure..?

    Please reread...

  • RE: Errors not being ignored

    Phil Parkin (2/21/2012)


    Charmer (2/21/2012)


    If Ignore Failure does not work exactly....then why should we have a such condition...or when will it work if we do Ignore Failure..?

    Please reread Koen's response.

    Hi Phil,

    I...

  • RE: Errors not being ignored

    If Ignore Failure does not work exactly....then why should we have a such condition...or when will it work if we do Ignore Failure..?

  • RE: Without DateTime Column?

    Eric M Russell (2/20/2012)


    Charmer (1/24/2012)


    Hi Friends,

    i have table which does not have any date time column, but my need is to get some records depending on the...

Viewing 15 posts - 361 through 375 (of 544 total)