locked
Give one line spare SSIS package RRS feed

  • Question

  • Hi Friends,

    I have a small question. I was using Pulling data from TWO tables and loading into one text file.

    So my Question is I want to give one line  gap between those two tables data like this 

    How it is possible ? Could you please help on this.

    Note: I dont want to create views and in that joining all the columns.

    Thanks,

    Ramakrishna

     

    Friday, September 14, 2012 2:37 PM

Answers


  • http://btsbee.wordpress.com/

    • Marked as answer by BandSr Friday, September 14, 2012 3:46 PM
    Friday, September 14, 2012 3:42 PM

All replies

  • When you are selecting data from two tables, I reckon you are using 2 ole db source and "union"ing the result. If yes then put a ole db source between the two, selecting empty/ null values for your source column. Union all three such that you have an empty row between the 2 source datasets and plonk the "union"ed dataset into a flat file.


    http://btsbee.wordpress.com/

    Friday, September 14, 2012 3:05 PM
  • Thanks for your information 

    I was using two data flow tasks.

    one is for 1st table and second data flow task is for 2nd table..... and loading whole data into single flat files.

    Friday, September 14, 2012 3:13 PM

  • http://btsbee.wordpress.com/

    • Marked as answer by BandSr Friday, September 14, 2012 3:46 PM
    Friday, September 14, 2012 3:42 PM
  • Thank you verymuch for your information 

    that works well

    Friday, September 14, 2012 3:46 PM