DSXchange

As documented.

You don't need to do anything special. You should be able to import objects from a lower version into a higher version without issue.

Figured that was going to be the answer.

I'm curious how a Server job would have references to ORCHESTRATE in its SQL:

deepu09 wrote:they just restart the sequence after 5-10 mins. Then it will complete successfully

That kind of behaviour is almost always indicative of a resource issue. I too would wonder about the server load at the time it happens.

I agree, it's just a pivot. Hard-code three new columns with the 'column names' and then pivot them with their matching data column. Write out the file without enabling the column headings option.

#Parameter_Name#

Also, make sure you understand that parameter names are case sensitive.

p.p.s. Sorry for continuing the off-topic-ness of this but I always enjoyed talking to Karen and she liked the "interesting" problems I would send her way on occassion. And dang, she knew that sh...tuff inside and out, down all the way to the internals. If you get a chance Arnd, pass along...

Trust me, it doesn't take much of a mistake to corrupt a project. Been there, done that, got the t-shirt. :oops: In my case, it was a simple typo with regards to the category of the job which took the help of the awesome Karen Powers to resolve. Your issue may not have been any issue with the job it...

raju4u wrote:Here I should not convert it in to Char ,it should be Decimal only.

Yes, you should. Flat files are just character data after all. Of course, make sure you're still writing out a valid decimal value but as noted, convert it to a string so you have full control over the formatting.

Behaviour like that I would be reporting to your official support provider as it seems more like a bug than anything else to me.

An exact search for "Non-pipe (or non-virtual data set) with .v in its name" returns 32 matches, should be some useful information there.

SURA wrote:I thought of config issue.

I thought of bug.

I don't have time for much of an answer but yes - you can certainly do that with a "generic" job and many people here have done exactly that. You'll also find multiple conversations on the topic. At a high level it involves the use of schema files and runtime column propagation, aka RCP.

Can you post a representative example of one?