We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SSIS - Putting data from SQL 2005 - Excel 2003

TechMonster
TechMonster asked
on
Medium Priority
382 Views
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?


Thanks.
Comment
Watch Question

Commented:
Could you write out a csv file instead and load that into excel?
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
You can use Data flow task.
G Trurab KhanSnr. Development Manager
CERTIFIED EXPERT

Commented:
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

Commented:
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.
   
G Trurab KhanSnr. Development Manager
CERTIFIED EXPERT

Commented:
Ckeck if there is any linebreak or carriage return (char(13, char(10))in the text field you are converting
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Not able to find solution
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.