SSIS Package not updating a column
I have a table thats being pulled from a different server. The table was missing a column that was added later so I updated my SSIS Package to bring in the column. The SSIS worked fine the first time around but now I've scheduled it to run and though the columns are mapped correctly the new column isnt being populated. When I create a new SSIS package it runs and populates the field but soon as the SSIS Package is scheduled the column is not being updated. Please advise what could be the cause.
sql ssis
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
add a comment |
I have a table thats being pulled from a different server. The table was missing a column that was added later so I updated my SSIS Package to bring in the column. The SSIS worked fine the first time around but now I've scheduled it to run and though the columns are mapped correctly the new column isnt being populated. When I create a new SSIS package it runs and populates the field but soon as the SSIS Package is scheduled the column is not being updated. Please advise what could be the cause.
sql ssis
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
add a comment |
I have a table thats being pulled from a different server. The table was missing a column that was added later so I updated my SSIS Package to bring in the column. The SSIS worked fine the first time around but now I've scheduled it to run and though the columns are mapped correctly the new column isnt being populated. When I create a new SSIS package it runs and populates the field but soon as the SSIS Package is scheduled the column is not being updated. Please advise what could be the cause.
sql ssis
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
I have a table thats being pulled from a different server. The table was missing a column that was added later so I updated my SSIS Package to bring in the column. The SSIS worked fine the first time around but now I've scheduled it to run and though the columns are mapped correctly the new column isnt being populated. When I create a new SSIS package it runs and populates the field but soon as the SSIS Package is scheduled the column is not being updated. Please advise what could be the cause.
sql ssis
sql ssis
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
asked Nov 15 '18 at 11:38
Otshepeng DitshegoOtshepeng Ditshego
699
699
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The path in SQL Agent Job Step is not correct or you not correctly saved SSIS package.
If SSIS package in SQL agent runing from File system, you must build package - Menu->Build->Build[package name]
if SSIS package is runing from SSISDB you must deploy package in server.
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
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%2f53318651%2fssis-package-not-updating-a-column%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
The path in SQL Agent Job Step is not correct or you not correctly saved SSIS package.
If SSIS package in SQL agent runing from File system, you must build package - Menu->Build->Build[package name]
if SSIS package is runing from SSISDB you must deploy package in server.
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
add a comment |
The path in SQL Agent Job Step is not correct or you not correctly saved SSIS package.
If SSIS package in SQL agent runing from File system, you must build package - Menu->Build->Build[package name]
if SSIS package is runing from SSISDB you must deploy package in server.
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
add a comment |
The path in SQL Agent Job Step is not correct or you not correctly saved SSIS package.
If SSIS package in SQL agent runing from File system, you must build package - Menu->Build->Build[package name]
if SSIS package is runing from SSISDB you must deploy package in server.
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
The path in SQL Agent Job Step is not correct or you not correctly saved SSIS package.
If SSIS package in SQL agent runing from File system, you must build package - Menu->Build->Build[package name]
if SSIS package is runing from SSISDB you must deploy package in server.
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
answered Nov 15 '18 at 11:49
JustinJustin
7,84162339
7,84162339
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
add a comment |
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
I am running the SSIS Package using the task scheduler and a BAT file
– Otshepeng Ditshego
Nov 15 '18 at 12:48
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
Which file you using Packagedierctory->PackageNamedirectory->dtsx or Packagedierctory->PackageNamedirectory->bin->dtsx
– Justin
Nov 15 '18 at 13:28
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%2f53318651%2fssis-package-not-updating-a-column%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
