插入metaData new表
INSERT INTO [config].[tbl_data_source_new](
[sourceSchema]
,[sourceTable]
,[destinationContainer]
,[destinationFolder]
,[destinationFile]
,[sourceScript]
,[isIncremental]
,[lastUpdated]
,[sourceType]
,[isfiltered])
VALUES(
'SalesLT'
,'SalesLT.Customer'
,'raw'
,'Customer'
,'Customer.csv'
,'
SELECT [CustomerID]
,[NameStyle]
,[Title]
,[FirstName]
,[MiddleName]
,[LastName]
,[Suffix]
,[CompanyName]
,[SalesPerson]
,[EmailAddress]
,[Phone]
,[PasswordHash]
,[PasswordSalt]
,[rowguid]
,[ModifiedDate]
,getdate() as DataLoadedDate
,''SalesLT'' as SchemaName
,''Address'' as TableName
from [SalesLT].[Customer]
'
,0
,null
,'Sales'
,0
)
go
