Please close. It works now.

Looks like it is old bug in bcp command.

https://github.com/MicrosoftDocs/sql-docs/issues/2689

• This reply was modified 4 years, 10 months ago by  Dmitriy Burtsev.

You BCP format file says that the delimiter for the end of the 1st field should start with a pipe and end with a quote.  It doesn't for the...

There are an issue with STRING_DELIMITER in PolyBase
https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/9882219-polybase-allow-escaping-string-delimiters-within

It is under review since 2016.

I may in the future. I never work wit BIML before.

Let say you have to ETL several files to staging tables. You don't know how many tables. You don't know tables and files structure at design time.

Somebody else later...

No.

In my script I don't have table name, columns name, columns...

I know that. One need executable to create...

For production environment we prefer script solution to compiled executable.

I have to call C# from PowerShell as a workaround.

# version 1

# usage .\LoadTest "N:\DirName\LoadTest2.csv" "SERVER01.TestDB..LoadTest" ","

Param(

[Parameter(Mandatory=$True,Position=1)]

[string]$FromFileName,

[Parameter(Mandatory=$True,Position=2)]

[string]$ToTableName,

[Parameter(Mandatory=$True,Position=3)]

[string]$terminator

)

$ErrorActionPreference="Stop"

Set-PSDebug -Strict

[bool]$b = [System.IO.File]::Exists($FromFileName)

if (-Not $b)

{

Write-Output "File not found"

exit 1

}

# get...

Thank you

Sometimes we need to pass variables to the trigger.

This is my output:

UserID

123

I like your idea but I make a few changes to meet my environment.

CREATE VIEW dbo.v_jobs

AS

SELECT j.name AS JobName,

...

exec sp_helptext 'sp_spaceused'

It is query sys.dm_db_partition_stats