I'm attempting to do a simple test of copying data from an on-prem database to an Azure database. The error message I receive is on the Azure dataset:
Invalid parameter 'ConnectionString' provided to copy activity. This could be caused by the mismatch between the information in encrypted credential and the information in connection string. If connection string is updated, generate the encrypted credential again and update the LinkedService.
I had Azure build their sample pipeline and pointed the Azure db to the same one I'm using below and then copied the syntax and even used the linked service it generated for the same Azure database, but I still can't seem to resolve it.
Here is the code for the linked service:
{
"name": "AzureSqlLinkedService",
"properties": {
"description": "",
"hubName": "onpremcnodsdf_hub",
"type": "AzureSqlDatabase",
"typeProperties": {
"connectionString": "Data Source=tcp:abc123.database.windows.net,1433;Initial Catalog=TestDatabase;Integrated Security=False;User ID=userid;Password=**********;Connect Timeout=30;Encrypt=True"
}
}
The dataset:
{
"name": "AzureSQLDatasetTemplate2",
"properties": {
"structure": [
{
"name": "StoreID",
"type": "String"
},
{
"name": "Nickname",
"type": "String"
},
{
"name": "Address",
"type": "String"
},
{
"name": "City",
"type": "String"
},
{
"name": "State",
"type": "String"
},
{
"name": "ZipCode",
"type": "String"
},
{
"name": "PhoneNumber",
"type": "String"
},
{
"name": "EntityID",
"type": "String"
},
{
"name": "Owner",
"type": "String"
},
{
"name": "Email",
"type": "String"
},
{
"name": "ModifiedDate",
"type": "String"
},
{
"name": "ModifiedBy",
"type": "String"
}
],
"published": false,
"type": "AzureSqlTable",
"linkedServiceName": "AzureSqlLinkedService",
"typeProperties": {
"tableName": "cStoreTest"
},
"availability": {
"frequency": "Day",
"interval": 1
}
}
And the pipeline:
{
"name": "ADFTutorialPipelineOnPrem",
"properties": {
"description": "This pipeline has one Copy activity that copies data from an on-prem SQL to Azure Sql",
"activities": [
{
"type": "Copy",
"typeProperties": {
"source": {
"type": "SqlSource",
"sqlReaderQuery": "SELECT * FROM CNIT.dbo.cStore"
},
"sink": {
"type": "SqlSink",
"sqlWriterStoredProcedureName": "spcStoreTestInsert",
"sqlWriterTableType": "cStoreTestType",
"writeBatchSize": 100,
"writeBatchTimeout": "01:00:00"
}
},
"inputs": [
{
"name": "SQLServerDatasetTemplate"
}
],
"outputs": [
{
"name": "AzureSQLDatasetTemplate2"
}
],
"policy": {
"timeout": "01:00:00",
"concurrency": 1,
"executionPriorityOrder": "NewestFirst",
"style": "StartOfInterval"
},
"scheduler": {
"frequency": "Day",
"interval": 1
},
"name": "CopyFromOnPremtoAzure",
"description": "Copy data from on-prem SQL server to Azure SQL"
}
],
"start": "2014-05-01T00:00:00Z",
"end": "2014-05-05T00:00:00Z",
"isPaused": false,
"hubName": "onpremcnodsdf_hub"
}
I'm very new to Azure so any insight you may have would be greatly appreciated.
Thanks!
Aucun commentaire:
Enregistrer un commentaire