DSXchange

He did. At least for the "days" part, the month he left up to you.

You have a "size mismatch"... fix that. How much data did you think would fit into a DECIMAL(1,0) field?

Yup.

Decimal.

So... you are thinking that you can subtract the two month numbers regardless of the year? Unfortunately, it's not as simple as that. Another game you can play, if you don't want to worry about how many days are in any given month, is to do some math on the components. Take the year and month from e...

It is available while the job is running.

Do the calculation in the job, not the SQL. That or talk to a SQL Server guru there to get the proper SQL syntax, whatever that may be.

Don't use Float.

So out of all that code you just need the call to DSGetLinkInfo and the log function. Why "DSLogWarn"? Why not simply "DSLogInfo"?

There's no actual attaching going on here, it is just querying the current job so not quite clear how one would get a "BADHANDLE".

Let me conject for a moment. :wink: As noted, it is being passed to a "user defined" a.k.a a custom routine that is unknown to us. However, certain functions include an "Error Code" argument that tell the function how to handle any errors it encounters. From the documentation for...

So... a Managed File Transfer? Using what tool / utility?

OK... sorry but here are my problems. One is that I don't "do SQL Server" so the nuances of handling DATETIME fields there rather than say in Oracle are not something I'm familiar with. That means I don't how implicit conversions of things like dates or timestamps are handled internally th...

And please don't think it is any kind of a Good Idea to convert Server jobs to Parallel en masse. Pick and choose. Convert those that need to be converted, ones that would benefit from it.

Get rid of the "select", it is not needed. If you can get your parameter in DD/MON/YYYY format, try: > CONVERT(DATETIME,'#p_MaxDate#') otherwise match the Style Code to the format. You picked 111 which is for a Japanese date.