Forum Replies Created

Viewing 15 posts - 1 through 15 (of 53 total)

  • RE: Logic to check for empty table before joining

    Thank Grant. I will try your suggestion. Just wanted to make sure I' doing it in a correct way.

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    December 11, 2017 at 7:24 pm

    #1971688

  • RE: How can I capture SSIS events in my package at one place

    Karen A. Ferrara-426245 (2/18/2014)

    I understand -- If you add the event handler to just the package failure tab and set all your tasks to FailParentOnFailure = false and FailPackageonFailure =...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    February 18, 2014 at 11:09 am

    #1690002

  • RE: How can I capture SSIS events in my package at one place

    Well!! I guess template will not work for me. Let me try to rephrase my requirement.

    My ssis pkg contains many task (on the avg 20 task) and for each task...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    February 18, 2014 at 10:48 am

    #1689992

  • RE: How can I capture SSIS events in my package at one place

    Even I'm doing the same thing. The only difference is I'm using sepate pkg to write my logging logic & calling it inside event handlers.

    My actual question was, is there...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    February 18, 2014 at 6:35 am

    #1689874

  • RE: Weird issue with SSIS logging.

    I tried running it with DTEXEC utility. Still the same output.

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    January 30, 2012 at 5:56 pm

    #1440307

  • RE: Issue on importing data from Excel 2010 to SQL Server 2008R2

    Its seems from your statement that there is some problem with columns mapping. Can you share some portion of your excel (if possible) so that I can see why you...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 31, 2011 at 3:28 am

    #1331850

  • RE: SSIS QUESTION

    What data source are you using ? Could suggest a solution only if you can give me some idea of this.

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 20, 2011 at 11:23 am

    #1327844

  • RE: Visual Studio 2005 & Integration Packages

    Agreed with CozyRoc.There should not be any problem with installing the patch. What I personally think behind alien behavior for your SSIS is that there must be some problem with...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 20, 2011 at 10:00 am

    #1327796

  • RE: Parent Package not continuing after Child Pkg called and completed

    If the succeeding task is not getting fired that simply means there is some problem with your precedence constraint. Crosscheck your precedence constraint.

    Attach your package image (just to have...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 20, 2011 at 3:54 am

    #1327534

  • RE: How prevent to load the dublicate row in OLEBD destination

    Well, I am also working on a scenario very similar to yours where we dont have any primary key defined for our datawarehouse table but we have to incremental load...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 20, 2011 at 2:58 am

    #1327520

  • RE: Dynamically populating variable value not working

    Are you doing this in Execute SQL Task ?? If yes then this is not the correct eway to assign value to the variable. If no then give a bit...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 19, 2011 at 12:20 am

    #1326896

  • RE: Phone Numbers in Excel being loaded as NULL to SQL Server

    let me know if it's not resolving your problem..

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 17, 2011 at 7:51 am

    #1325819

  • RE: Phone Numbers in Excel being loaded as NULL to SQL Server

    Hey,

    Just gone through the Excel that you have posted. Your getting NULL which is obvious in your case. Its's behaviour of MS SSIS engine.

    SSIS engine, by defauly, scans 1st 8...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 17, 2011 at 7:48 am

    #1325815

  • RE: Create a script which is restartable

    Grant Fritchey (5/17/2011)

    Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 17, 2011 at 6:49 am

    #1325744

  • RE: Create a script which is restartable

    srikant maurya (5/17/2011)

    Use just simple transaction

    You're right but that's not possible in my case. The scenario is, I had created Autosys jobs which calls and execute DTS package(s) which...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    May 17, 2011 at 1:23 am

    #1325631

Viewing 15 posts - 1 through 15 (of 53 total)