Forum Replies Created

Viewing 15 posts - 31 through 45 (of 47 total)

  • RE: Data Import from CSV file

    Phil Parkin (11/27/2012)

    rhythm.varshney (11/27/2012)

    Phil Parkin (11/27/2012)

    There is no good way of doing this in SSIS - I'm with Jeff on this one.

    If you want to put an SSIS 'wrapper' round...

    November 29, 2012 at 3:40 pm

    #1564081

  • RE: Left Join doesn't return all recodrs in left table

    helal.mobasher 13209 (11/27/2012)

    I am linking two tables with left outer join. I need to keep all the records in the left table even though there are no matches in the...

    November 28, 2012 at 12:13 am

    #1562935

  • RE: Data Import from CSV file

    Phil Parkin (11/27/2012)

    There is no good way of doing this in SSIS - I'm with Jeff on this one.

    If you want to put an SSIS 'wrapper' round it, something like...

    November 27, 2012 at 10:32 am

    #1562766

  • RE: Data Import from CSV file

    Jeff Moden (11/26/2012)

    rhythm.varshney (11/26/2012)

    Phil Parkin (11/26/2012)

    rhythm.varshney (11/26/2012)

    waiting for your valuable input guys........

    You still have not asked a single question - there is nothing to respond to.

    please suggest the way to...

    November 26, 2012 at 10:27 pm

    #1562499

  • RE: Data Import from CSV file

    Phil Parkin (11/26/2012)

    rhythm.varshney (11/26/2012)

    waiting for your valuable input guys........

    You still have not asked a single question - there is nothing to respond to.

    please suggest the way to get the data...

    November 26, 2012 at 5:31 pm

    #1562468

  • RE: Data Import from CSV file

    waiting for your valuable input guys........

    November 26, 2012 at 10:48 am

    #1562316

  • RE: Data Import from CSV file

    Any suggestion on this.......

    November 25, 2012 at 8:40 am

    #1562050

  • RE: Data Import from CSV file

    Phil Parkin (11/25/2012)

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    So what is your question?

    I need to import the data into the table.The logic is If Type is MSAD then it should...

    November 25, 2012 at 5:27 am

    #1562037

  • RE: Data Import from CSV file

    Phil Parkin (11/25/2012)

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    So what is your question?

    I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column...

    November 25, 2012 at 5:20 am

    #1562035

  • RE: Data Import from CSV file

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    So what is your question?

    I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column of table...

    November 25, 2012 at 5:09 am

    #1562033

  • RE: Data Import from CSV file

    Phil Parkin (11/25/2012)

    So what is your question?

    I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column of table with...

    November 25, 2012 at 4:25 am

    #1562030

  • RE: Is derived column better for performance of a package ?

    Randy Knight (11/13/2012)

    rhythm.varshney (11/13/2012)

    Yes, actually if you see my comments I mentioned that I am performing UPINSERT logic on the basis of staging table which hold around 50 K records...

    November 13, 2012 at 11:53 pm

    #1558747

  • RE: Is derived column better for performance of a package ?

    Evil Kraig F (11/12/2012)

    Randy Knight (11/12/2012)

    rhythm.varshney (11/12/2012)

    yes.I am importing the data to staging table as it is and there I am applying split on a column say name into first...

    November 13, 2012 at 6:46 pm

    #1558714

  • RE: Is derived column better for performance of a package ?

    Randy Knight (11/11/2012)

    So you are importing the column to your staging table in it's native format and then splitting it from there? On what basis are you splitting it...

    November 12, 2012 at 10:45 am

    #1558241

  • RE: Is derived column better for performance of a package ?

    rhythm.varshney (11/10/2012)

    I have a scenario where an excel have thousands of records with say 20 columns. In which their is a column which I need to split while inserting it...

    November 11, 2012 at 7:40 pm

    #1557997

Viewing 15 posts - 31 through 45 (of 47 total)