You should actually have 2 different versions of this, one for nvarchar and another for varchar. A varchar over the length of 1billion~ characters would be truncated when it is...

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't get done. ...

Gracias por responder. El parametro  @ ParmDefinition  Es una variable Unicode exigida por el procedimiento sp_executesql. Desde tu perspectiva, estoy seguro que no es una invocacion a otro store...

As for "real" keys, are you serious??? Unique index, possibly a constraint for validation (for keys that have some regular pattern or rules) and boom, done. Move on. How...

Tell your connection manager your text is Quote Identified (with the " character); it's an simple as that. Then...

You want the box highlighted in the below image (which says <none>), and need to put in ":

Set the value of the Quote Identifier to " in your connection manager; then refresh the columns.

Honestly, I don't really trust converters. You're far better off doing this yourself. Yes, it might seem like a longer task, but converters make mistakes, can't replicate certain behaviour, or...

Updated to no longer assume, all tables have an IDENTITY property column:

USE UNFI_WEST_F;
GO

DECLARE @SQL nvarchar(MAX),
        @CRLF nchar(2) = NCHAR(13) +...

Is there a reason you can't launch the Powershell window as a different user?

How did you execute the package? Did you right-click and select 'Execute Task' by any chance?

Also, if you double-click on the precedence constraint (the line between the two tasks),...

Have a look at the progress pane, rather than the Debug window.

Fair enough, we all do them. Took me 20 minutes to work out that i'd typed 2 instead of 1 in a statement earlier, and couldn't for the...

Why omit QUOTENAME in the initial statement?

Personally, I would do it like this, and not just...

• This reply was modified 5 years, 11 months ago by Thom A.

If you don't want underscores in your final value, why are you replacing " " with "_"? That's like saying you don't want a blue car, you want a red...