Automate metadata creation

sandeepgs · Post by **sandeepgs** » Tue Oct 07, 2008 12:10 am

Hi,

We are trying to automate the metadata creation and so we have written a excel macro to fulfill the requirement.

We are able to create .dsx file but when we are trying to import the .dsx file using datastage manager it is throwing out an error

Error message in Datastage manager:

Unknown property name 'Sql'
Object = SubObject of Test\\MEATADATAEXCEL
Class = Cmetacolumn

ray.wurlod · Post by **ray.wurlod** » Tue Oct 07, 2008 12:32 am

Looks like the DSX file might have become corrupted. What's been used to open it since it was exported?

throbinson · Post by **throbinson** » Tue Oct 07, 2008 5:01 am

I may be mis-reading this post but it seems like you have written an Excel macro to create a .dsx file for your table definitions. You are then asking why these .dsx s do not import into DataStage. If this is correct then the answer is easy; Your reverse engineering (hack) of the DataStage export/import functionality is in error. Fix it. Does it really need to be said that the Excel macro must recreate exactly the format and layout of a .dsx?
My apologies if I have read this post wrong.

chulett · Post by **chulett** » Tue Oct 07, 2008 7:14 am

No, I don't think you're reading it wrong. It's obvious their assertion that they were able to create an appropriate .dsx file is incorrect. Compare your file to a 'real' file - what's missing / wrong?

sandeepgs · Post by **sandeepgs** » Thu Oct 16, 2008 2:45 am

Hai Everyone,

Thanks for your response.
It is problem with the format of data in the dsx.

We are able to load metadata into datastage.

kduke · Post by **kduke** » Thu Oct 16, 2008 10:26 am

Next time I would use XML.