thanks phil, do you mean all on the same single pc?   That's the kind of feedback i was hoping for.   That way no one instance of sql could interfere...

Have you considered using multiple local VMs, one per project?

Not sure what your question is, please elucidate.

This is exactly what I was thinking, too.

What do you mean by the 'SSISDB category'?

What does the package do? Is there any file system interaction?

If you open the All Executions report for the package, does that provide any clues as to the issue?

I've not used geography:, but perhaps this post is a similar issue?

https://stackoverflow.com/questions/40558663/spatial-query-a-net-framework-error-occurred-during-execution-of-user-defined

At no point did I suggest that Jonathan's code...

Maybe the application settings for SQL within the Application is different than what I'm running in SSMS

That was my first thought. You should check this.

There must be a more elegant way of doing this, but I ran out of time. This appears to work with the existing data:

WITH filtered
AS (SELECT p1.Code
...

Looks promising, but I haven't used it.

You need to start doing some R&D.

Once you figure out how to code the REST calls you need, whacking that code into SSIS isn't...

Did you try Jonathan's code?

As far as I know, C# cannot do this conversion natively.

NitroPDF does not appear to have an API, so its functions cannot be called from other applications. You'll have to...

Here's a possible way. It assumes that if a hyphen appears anywhere in the underlying text string, it must mean that the string is a negative number.

DROP...

I've made the test data generation a little more user-friendly (and changed the 'Code' for the second set of data to differentiate from the first)

DROP TABLE IF...

• This reply was modified 1 years, 9 months ago by Phil Parkin.