Page 1 of 1

Data not getting loaded into target table

Posted: Wed Jan 16, 2008 9:12 pm
by aschand
Source is spreadsheet in a sequential file

there are 6 tabs in one single spreadshheet
two tabs are joined as one in a sequential file ... like that 3sequential files are made..

these 3 seq files are joined using join stage and then written to a sequential file .....

It worked perfectly and data could be loaded into a flat file.

Now when the I addded a transformed to the join stage and added target as sql server then i had problem... the data is not getting loaded.... i mapped everything and there are no compilation errors...

please help me on this.

thanks
aschand

Posted: Thu Jan 17, 2008 4:25 am
by us1aslam1us
what does you logs in the director say? post them here...

Posted: Thu Jan 17, 2008 5:35 am
by ray.wurlod
Is it the Transformer or the SQL Server stage? To answer this question lose the SQL Server stage and replace it with a Sequential File stage.