SSIS excel sheet

Question

SSIS excel sheet

coffeewithmax

Old Hand

Points: 353
More actions
September 16, 2010 at 5:23 am

#238252

hello
In one of child package while loading data from excel sheet to destination source, i am able load the header part of the excel but not data in it . when i run the package individually i am getting header as well as data .
please help me out
Best Regards
Raj

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

coffeewithmax (9/16/2010)
hello
In one of child package while loading data from excel sheet to destination source, i am able load the header part of the excel but not data in it . when i run the package individually i am getting header as well as data .
please help me out
Best Regards
Raj

Could you be more specific?

Raunak J

coffeewithmax Old Hand Points: 353 More actions · Answer 2

thanks for response

IN PACKAGE

i have a parent package in for loop i am calling a child package .

in the child package - data flow i am loading a excel sheet in to sql

here in the preview of excel datasource i can view the data but in first row its showing XXXXXXXXXXXXXX

i can view header and data , but data is correct from second row in first row it is taking as XXXXXXXXXXXXXX i cant understand this . when i add a dataviwer only header names are loaded not the data but in preview i can see the data

Hope u understood the problem

IN SAMPLE

when i load same excel in separate package here i am not getting xxxxxxxxxxxx its done successfully

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 3

coffeewithmax (9/16/2010)
thanks for response
IN PACKAGE
i have a parent package in for loop i am calling a child package .
in the child package - data flow i am loading a excel sheet in to sql
here in the preview of excel datasource i can view the data but in first row its showing XXXXXXXXXXXXXX
i can view header and data , but data is correct from second row in first row it is taking as XXXXXXXXXXXXXX i cant understand this . when i add a dataviwer only header names are loaded not the data but in preview i can see the data
Hope u understood the problem
IN SAMPLE
when i load same excel in separate package here i am not getting xxxxxxxxxxxx its done successfully

Raj,

What is the datatype of the Hedaer and that of rows below the header row?

Raunak J

coffeewithmax Old Hand Points: 353 More actions · Answer 4

for both external and output column it is Unicode string [DT_WSTR]

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Are you running in 32-bit or in 64-bit mode?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

coffeewithmax Old Hand Points: 353 More actions · Answer 6

coffeewithmax

Old Hand

Points: 353

September 17, 2010 at 3:39 am

#1222849

32 bit

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

If you write the data to a table, what are the actual values that you get?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

coffeewithmax Old Hand Points: 353 More actions · Answer 8

header row i am getting first name last name etc ... but data in table i cant see .. for example jhon elton

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Allright, it is time to dive into the details.

How did you set-up your packages? What tasks/components did you use? What connectors did you use? What are the expressions/variables/package configurations that you use?

Be as much specific and detailed as possible.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 10

da-zero (9/20/2010)
Allright, it is time to dive into the details.
How did you set-up your packages? What tasks/components did you use? What connectors did you use? What are the expressions/variables/package configurations that you use?
Be as much specific and detailed as possible.

This post been eating my head since long...a much needed relief :-):-):-)

Raunak J