Issue while reading a from container how do i put the data in sql table with this issue file
Error found when processing 'Csv/Tsv Format Text' source 'xyz_File' with row number 7: found more columns than expected column count: 65.. Activity ID:c310daeb-7c87-4176-95c3-47bab56a9b1b
I have tried with "u0001" separator and it's providing only a single column.
Like Below.
col1,col2,col3......Col150
It should appear like.
col1,col2,col3......Col150==>>col1 Col2 col3
azure azure-data-factory-2 asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
add a comment |
Error found when processing 'Csv/Tsv Format Text' source 'xyz_File' with row number 7: found more columns than expected column count: 65.. Activity ID:c310daeb-7c87-4176-95c3-47bab56a9b1b
I have tried with "u0001" separator and it's providing only a single column.
Like Below.
col1,col2,col3......Col150
It should appear like.
col1,col2,col3......Col150==>>col1 Col2 col3
azure azure-data-factory-2 asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
add a comment |
Error found when processing 'Csv/Tsv Format Text' source 'xyz_File' with row number 7: found more columns than expected column count: 65.. Activity ID:c310daeb-7c87-4176-95c3-47bab56a9b1b
I have tried with "u0001" separator and it's providing only a single column.
Like Below.
col1,col2,col3......Col150
It should appear like.
col1,col2,col3......Col150==>>col1 Col2 col3
azure azure-data-factory-2 asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
Error found when processing 'Csv/Tsv Format Text' source 'xyz_File' with row number 7: found more columns than expected column count: 65.. Activity ID:c310daeb-7c87-4176-95c3-47bab56a9b1b
I have tried with "u0001" separator and it's providing only a single column.
Like Below.
col1,col2,col3......Col150
It should appear like.
col1,col2,col3......Col150==>>col1 Col2 col3
azure azure-data-factory-2 azure azure-data-factory-2 asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
asked Jan 2 at 10:10
Gaurav GangwarGaurav Gangwar
143
143
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Try defining the schemas in the copy activity.
Also next time you ask try to explain a bit more your case so we can help you in a better way.
Hope this helped!
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004443%2fissue-while-reading-a-from-container-how-do-i-put-the-data-in-sql-table-with-thi%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try defining the schemas in the copy activity.
Also next time you ask try to explain a bit more your case so we can help you in a better way.
Hope this helped!
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
add a comment |
Try defining the schemas in the copy activity.
Also next time you ask try to explain a bit more your case so we can help you in a better way.
Hope this helped!
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
add a comment |
Try defining the schemas in the copy activity.
Also next time you ask try to explain a bit more your case so we can help you in a better way.
Hope this helped!
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
Try defining the schemas in the copy activity.
Also next time you ask try to explain a bit more your case so we can help you in a better way.
Hope this helped!
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
answered Jan 2 at 13:37
Martin Esteban ZuritaMartin Esteban Zurita
878516
878516
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
add a comment |
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
You mean I need to write the schema manually. Can you explain little better.
– Gaurav Gangwar
Jan 3 at 6:10
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
Click on the copy activity, then on the lower window click "Mapping", then "Import Schemas". After that you can map columns from source to columns in the sink. This should solve your column errors.
– Martin Esteban Zurita
Jan 3 at 14:29
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004443%2fissue-while-reading-a-from-container-how-do-i-put-the-data-in-sql-table-with-thi%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
