DSXchange

Explain about the difference between the jobs :either stage wise or property wise

You can use Aggregator stage to group my the key value

As the message itself clearly tells you, there is a column name that is similar in the two links that you have used. Try the message handler to avoid the message

Can use varchar datatype to read it through the sequential file and then use type conversion which is relevant to your requirement..

Which function are you using..?
Try this TimestampToString(DATA,[%yyyy-%mm-%dd])

ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...

I think he want to convert Timestamp to String ""while convert timespamp to string getting warnings""

are you trying to convert "Timestamp to String" or "String to Timestamp"..Can you able to read the data in the Source file??

Remove the %hh%mm%ss and try to execute

Please post the topic in appropriate forum

You can also use trim function to trim the string "," in transformer stage

It was user specified and hence you can use your own parameters for DB connection. The commonly used are DataSource,Username, PassWord,HostName etc..

I think you can write a stage variable that add the value of 3 to your date 1 with constraints not exceeding the date2

Thanks for all,
I think i have to work out different options....

Thank you once again for all,

Can we use the difference in the date (in the file name) while loading the file and rejectin the already loaded file?

Thanks,

Thank you all for your replies,
But now i have a doubt about the dataset stage
:: I am overwriting a dataset here, If there are no records passed ,then the dataset should be emptied.But i am having the past run records. Why is it so....
Please clarify my doubt

Thanks to all once again,