Data not getting loaded into target table

aschand · Post by **aschand** » Wed Jan 16, 2008 9:12 pm

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

us1aslam1us · Post by **us1aslam1us** » Thu Jan 17, 2008 4:25 am

what does you logs in the director say? post them here...

ray.wurlod · Post by **ray.wurlod** » Thu Jan 17, 2008 5:35 am

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.