SSIS - Putting data from SQL 2005 - Excel 2003

Posted on 2011-04-19
Last Modified: 2012-06-21
Seems to have a hard time with SQL data that is over 250 characters.  Need to do some sort of bulk load into excel where it would not matter how much text is being transferred to excel.
Do I use the VBA Script task?

Question by:TechMonster
    LVL 7

    Expert Comment

    Could you write out a csv file instead and load that into excel?
    LVL 21

    Expert Comment

    by:Alpesh Patel
    You can use Data flow task.
    LVL 8

    Expert Comment

    There wont be any problem excell may not be displaying the characters in a coulmn as maximum length for display is 255 but the data is there.

    Just convert the data to excel. Select the column conaining long text in converted Excel data then just format the cell (using FORMAT-CELLS option from the menu) in excell & check the Wrap Text checkbox. It will then display the cell contents in multiple rows.

    Author Comment

    Could you write out a csv file instead and load that into excel? - Yes, tried that.  The Csv file does display properly. But going from csv to excel..I run into the same problem.

    You can use Data flow task.

     - I am.  That contains the excel destination task.

    Ghunaima - the full range of the text should be in the excel formula bar. All the data is simply not there.  It only list a few characters.   I have set my length on my outputs/inputs in the SSIS to 4000 characters.  

    I'm stumped.
    LVL 8

    Expert Comment

    Ckeck if there is any linebreak or carriage return (char(13, char(10))in the text field you are converting

    Accepted Solution

    i was not able to resolve my problem.  Went with alternative route

    Author Closing Comment

    Not able to find solution

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now