locked
SSIS package for .csv file task RRS feed

  • Question

  • Hi all,

    Need some guidance for SSIS package..

    I'm creating SSIS package for to get .csv file to my local server and transfer it to FTP.

    Step 1. I use OLE DB Source and I used code to get my data from the database.   When I right do right click and edit on OLE DB source and go to the columns tab  external column and output columns are matching  but when I go to the Flat file destination > mapping tab on Available input column and available destination column are not matching so when i get .csv file with data and open in excel my data been shift over to other columns. Is there any solution to my data not get shift over to other columns? 

    Thanks in advance.

    Friday, January 10, 2014 5:25 PM

Answers

  • Then is it that you changed your source query (added/modified few columns) after you created connection manager? Otherwise the metadata wont have any mismatches.


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Tuesday, January 14, 2014 12:03 PM
    • Marked as answer by Mike Yin Monday, January 20, 2014 2:52 PM
    Friday, January 10, 2014 5:49 PM
  • I would delete and re-create the flat file destination.
    • Proposed as answer by Mike Yin Tuesday, January 14, 2014 12:03 PM
    • Marked as answer by Mike Yin Monday, January 20, 2014 2:52 PM
    Friday, January 10, 2014 5:52 PM

All replies

  • How did you generate the csv connection manager. By default when you create manager by connecting OLEDB source and specify the format as comma delimited the available columns are automatically taken from the source to form the file columns. and when you go to mapping tab they will automatically match. The fact that it doesnt match mean you already had a csv file based on which you created connection manager. Is that what you did? Did you browse to an existing file when you created the connection manager?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Friday, January 10, 2014 5:41 PM
  • I'm generating csv connection manger as by default. I'm not browsing any an existing file when I create connection manager.
    Friday, January 10, 2014 5:44 PM
  • Then is it that you changed your source query (added/modified few columns) after you created connection manager? Otherwise the metadata wont have any mismatches.


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Tuesday, January 14, 2014 12:03 PM
    • Marked as answer by Mike Yin Monday, January 20, 2014 2:52 PM
    Friday, January 10, 2014 5:49 PM
  • I would delete and re-create the flat file destination.
    • Proposed as answer by Mike Yin Tuesday, January 14, 2014 12:03 PM
    • Marked as answer by Mike Yin Monday, January 20, 2014 2:52 PM
    Friday, January 10, 2014 5:52 PM