DSXchange

Define the field as a string, then you have full control over its format.

What does your testing show?

Several ways. Export the project and search the dsx file. Use the dsx file with something like what Chuck Smith has posted. Search the forums for queries mentioning OLETYPE for examples of how to directly query the repository. And if you've been good about leveraging metadata, you can use the Usage ...

Search for the patterns posted, Windows will find them for you.

Send a link with a single not null field to an Aggregator and tell it to Count them, then send that output to your table.

So... no errors or warnings, just no output from the stage? That's typically a mismatch between the XPath Expressions being used and the XML itself. Could you post both, see if we see anything that looks... amiss?

Sure, in between the things that *I* have to take care of. However, all we've done is gone around in a huge circle and you're right back where you started - an issue that has nothing whatsoever to do with your choice of compiler or the settings you've chosen. That message means exactly what it says ...

Post your xsd.

Create a stage variable. Doesn't need to be used but it does need to exist. Then use an appropriate constraint like @OUTROWNUM=1 to control the number of rows it generates.

You "disconnected" the Designer how? By simply closing it? If so, bad idea. Now you need to find that defunct session and disconnect it.

They're all Server jobs from what I recall and I never actually tried running any of them either... and no ability to do that right now.

You have to pass all parameters. Perhaps you should change the routine to take one delimited string as the parameter and then you could parse out whatever number were sent inside the routine?

Good Lord. Delete the new post you just created for no good reason before someone replies to it.

*Note: I deleted it - Andy*

No, where did I say that? I said you've posted no details about why you can't compile other than your original post which was not a compiler / configuration problem.

You'd need to provide a wee bit more detail than that for anyone to help. I'm assuming you've moved beyond 'cannot get exclusive access' to some other issue now, yes?