The VALUES constructor can be used to generate rows and row_number() can assign incrementing integers to the constructed rows...

Come back to us if you need more hints

I have to say though - this...

Documentation is slippery... but here is the event

select p.name, p.description, o.name, o.description

from sys.dm_xe_objects o

join sys.dm_xe_packages p

on p.guid = o.package_guid

where p.name='sqlserver'

and o.name like 'table_update_code_path'

Yep, it was 3:56pm, but...

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part of a bigger...

Change this line:

$FullCommand = '& "' + $DtExecPath + '" --% ' + $Params;

Then use

Invoke-Expression $FullCommand

Sounds like they are using ipsec to secure it, in which case you could use a linked server set up on your server pointing to their server.

They have provided you...

datetime to money and hierarchyid to varchar are listed as implicit...

sorry, got those round the wrong way...

money to datetime and varchar to hierarchyid are both implicit, so that is what...

*I cannot ignore it - please don't *

Now, check your routing table on the client - it should be re-configured to always send traffic via the internal nic for your...

One more variant for these which shows a...

Well, I would start by having your parameter names match the ones in the SP.

Maybe it is just a mistake in how you have posted this, but the procedure...

Well, you will find that while some people may be happy to open an Excel spreadsheet and figure things out, the best help will come if you provide readily consumable...

Lee Hopkins (9/27/2016)

---

I have a script that gives me a string of the columns and types.

I wan to use this result to create a declared table

DECLARE @listStr VARCHAR(Max)

SELECT @listStr =...

Please read the second link in my signature (by Jeff Moden)[/url] to help us to help you.

With the latest SSMS 2016, you can avoid this error by changing the default scripting option "Convert user defined data types to base types" to True.