February 17, 2009 at 3:54 am
Hi
I want to transfer data from SQL to EXCEL.
The datatype in SQL table is
Notes --> Varchar(1000)
The value less than 255 are transferred but the greater values are not transferred. The error i get for the greater values are
[Mgmt Report - OrderDiff [168]] Error: There was an error with input column "notesConverted" (545) on input "Excel Destination Input" (179). The column status returned was: "The value violated the schema's constraint for the column.".
Please help in resolving this issue
Thanks in advance
Priya
Regards
Priya
February 17, 2009 at 7:07 am
It sounds like you will need to use a derived column task to split the data in that column into multiple columns (Notes1, Notes2, Notes3, Notes4).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 17, 2009 at 8:24 am
Thanks for your response.
Is it is possible to create Excel Table in Execute SQL Task with Notes as Long Text and then proceed?
The transfer is successful with Execute SQL Task in DTS.
Just confused as I am not aware of the same in SSIS.
Can u please guide me with this...?
Thanks in advance
Priya
Regards
Priya
February 17, 2009 at 9:51 am
The only way I have found, and there may be a better way, is to create a dummy row in the Excel sheet with the columns properly sized. Then SSIS picks up the correct size or can be modified to accept the correct size.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply