Post reply

csv file name from column value

  • September 17, 2012 at 5:24 pm

    #264293

    I want to load dta from table to .csv file.In table there are two columns data_date and device.when i load the data from table to .csv it should use data_date column value in the filename..There is unique data_data value in the table.to ellaborate i have 1000 devices for particular day. I want to give the name to file as suppose i have "2012-09-16 00:00:00.000" value in the table then my file name should be like "filename_20120916.csv".if there is "2012-09-15 00:00:00.000" value in the table then my file name should be like "filename_20120915.csv".

  • September 17, 2012 at 5:47 pm

    #1538855

    weston_086 (9/17/2012)

    I want to load dta from table to .csv file.In table there are two columns data_date and device.when i load the data from table to .csv it should use data_date column value in the filename..There is unique data_data value in the table.to ellaborate i have 1000 devices for particular day. I want to give the name to file as suppose i have "2012-09-16 00:00:00.000" value in the table then my file name should be like "filename_20120916.csv".if there is "2012-09-15 00:00:00.000" value in the table then my file name should be like "filename_20120915.csv".

    What method do you intend to use to do the export?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • September 17, 2012 at 5:48 pm

    #1538856

    i am working on ssis.

  • September 17, 2012 at 6:43 pm

    #1538864

    My apologies. I'll have to defer to someone that knows SSIS.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply