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

    Thanks,
    Charmer

    March 14, 2012 at 5:45 am

    #1459099

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

    Thanks,
    Charmer

    March 14, 2012 at 3:12 am

    #1459037

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

    Thanks,
    Charmer

    March 13, 2012 at 2:55 am

    #1458337

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

    Thanks,
    Charmer

    March 12, 2012 at 9:55 am

    #1457969

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

    Thanks,
    Charmer

    March 12, 2012 at 9:14 am

    #1457938

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

    Thanks,
    Charmer

    March 12, 2012 at 9:10 am

    #1457932

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

    Thanks,
    Charmer

    March 12, 2012 at 8:01 am

    #1457865

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

    Thanks,
    Charmer

    March 12, 2012 at 7:49 am

    #1457856

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

    Thanks,
    Charmer

    March 9, 2012 at 4:43 am

    #1457067

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

    Thanks,
    Charmer

    March 9, 2012 at 4:17 am

    #1457058

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

    Thanks,
    Charmer

    February 21, 2012 at 5:45 am

    #1449634

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

    Thanks,
    Charmer

    February 21, 2012 at 5:32 am

    #1449624

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

    Thanks,
    Charmer

    February 21, 2012 at 5:17 am

    #1449612

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

    Thanks,
    Charmer

    February 21, 2012 at 4:30 am

    #1449591

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

    Thanks,
    Charmer

    February 21, 2012 at 1:21 am

    #1449515

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