I was thinking I needed to include a password however that's not the case and why I wanted to delete this after I realized that.

Anyway I including the column in...

Nothing since the last update. We had another occurrence of the error just a couple days ago. Before that it was a couple weeks.

The number of errors after patching went...

• This reply was modified 2 years, 7 months ago by  TangoVictor.

Nevermind - It's too bad there's not a delete option for posts.

Yeah your welcome Jeff! You've helped me quite a bit over the years so I'm glad this is helpful.

We did speak with an IBM engineer and he was going...

Resolution:

What we found is this process appears to be fetching rows one at a time. The number of rows multiplied by the latency seemed to confirm this hypothesis.

We...

Yeah I would definitely use .net if we're talking about possibly unsanitized data. It's going to be a struggle as the term "apt" probably won't always be used. You might...

Split implies that "apt" would be a delimiter in a string. This wouldn't be the case.

Ex. 413 W. Third Ave Apt 38 Morrison, NC 23669

You're just looking to...

• This reply was modified 2 years, 8 months ago by  TangoVictor.
• This reply was modified 2 years, 8 months ago by  TangoVictor.

Update on this.

We did see one instance of these errors after the update.  Before the updates it was happening daily.

If I run across any additional info will try to remember...

Just following up on this.

Patching was completed last night.

Current versions are now:

Microsoft SQL Server 2019 (RTM-CU15) (KB5008996) - 15.0.4198.2 (X64)

Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build...

Steve I grabbed that screenshot before I posted the reply. I also deleted the tags before posting my reply.

Just pointing out that the tags were filled in automatically and I...

TangoVictor - we have an open case with Microsoft but have not gotten anywhere so far. We are on SQL 2019 cu 11 and the same windows server install...

OK will do, current is SQL 2019 Std CU13 and patching to CU15 next week. It seems more like a Windows service/Active Directory is the issue, but who knows.

Server...

Thanks for the replies, apparently notifications weren't working. Site is still struggling I see.

Going to install the latest CU in test today and push it up to prod next...

You just need to use the DATEADD function.

DATEADD("DAY",-1,GETDATE())

Try this:

@[User::VarArchiveFolder]+Replace(Replace(Replace(Replace(@[User::VarFileName],".","_"+Substring((DT_WSTR,50) DATEADD("DAY",-1,GETDATE()),1,10)+"."),"-",""),":","")," ","_")

EDIT: Also I suggest trying to be more explicit with the date and not use substring on a datetime.

You can...

• This reply was modified 2 years, 9 months ago by  TangoVictor. Reason: Added alternate expression for getting the date

Here's an example of using a script component as a data source in a dataflow that outputs the delimited string as rows.

There doesn't appear to be an overload method that...

• This reply was modified 2 years, 9 months ago by  TangoVictor.
• This reply was modified 2 years, 9 months ago by  TangoVictor.