What is the SQL you're trying to run (use the Script button)?

Not sure what you're asking or telling us here. Could you try elaborating please? Your title, I'm afraid, doesn't mean anything to me either, as SSC is an English Speaking...

If you're using Package Deployment (not project with SSISDB), then the error is very clear; you don't have SSIS installed on the destination instance. You need it install to use...

Do you have SSIS instance on the instance? What deployment method are you using?

If this inside a For Each Loop, you can also turn off the error propogation. Open the Error Handler for the For Each Loop and create an error handler then...

Just got a bounce back from the "webmaster", as the email address is mispelt on the Contributions page (it has sqlservercental.com not sqlservercentral.com). Forwarded it to the correct address.

I've resubmitted the question; hopefully the space isn't at the end any more, but it's very difficult to tell in SSC's editor I'm afraid, as it rips out of the...

• This reply was modified 6 years ago by Thom A.
• This reply was modified 6 years ago by Thom A.

Already discussed above. I'll try and fix the mess that SSC has made of this question in the editor.

You say that the SP returns a key, where is this key stored, in the RDBMS as well? It is just logic based on the values of the 3 parameters?...

Hi Caojunhe24,

If you want to respond to the topic, doing so is the best place, not the DMs. 🙂

Caojunhe24 wrote:

thanks Thom, i guess i might have confused you to describe...

This look like SSC's text parser then adding a space. Nothing i can do about that. Unfortuantely I had a pig getting the thing to even look correct due to...

• This reply was modified 6 years ago by Thom A.

Aren't you just describing a headerless fixed width file? If so, why build a Script Component to iterate through the file, when a text file source would work much better.

Looks like it CUs again as

2019 is finally out for general release: SQL Server 2019 is now generally available

Time to start looking at the specs and what it really includes in the Standard Licences,...

On Windows 10? The online docs documents how to access it: https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15