Saturday, May 12, 2012 9:48 AMHi ,
we have to use Execute Process task in our project,here we are using checksum in place of SCD.In checksum we have a concern like if we select more than 50 columns in a 64-bit operating system it will not work properly means for us it's not working for update like if already existing record have any changes.To resolve this issue we have to run one executable file before execute this package.
Here we are designed the one package to work checksum in 64-bit environment, we have taken one more package there first we are using Execute Process Task then calling the actual package to work checksum and update records purpose.
In Execute process task in process window i am giving the Executable file .exe path and in Arguments place we are giving the actual package folder path like d:\packages\updatetable.dtsx/maxerrorcount" -1"/check point off , but i am getting warning "passing 6 arguments and expected 0 " like that. please update us how to provide path how we have to pass arguments here to run successfully . Thank you.......
Sunday, May 13, 2012 5:57 PMModerator
I think you have a very different issue with your checksum not working for more than 50 columns - there's something to that that you don't understand properly, because the bitness of the OS shouldn't have an impact on that.
The arguments you presented don't seem to make sense. You've got unpaired or mispaired quotations, improper use of slashes (a forward slash in what appears to be a file path), and you have spaces in parameters that should not have spaces.
I suggest you review the MSDN entry for DTExec to make sure you're crafting the arguments correctly. If this still does not appear to work for you, please post exactly how you've configured the Execute Process Task - not "something like this".
Talk to me now on
Monday, May 14, 2012 6:21 AM
In Executeprocesstask i am calling file system and giving values following way,
Executable: F:\apps\SQL2005 (x86)\90\DTS\Binn\DTExec.exe
Arguments: dtexec /f "K:\John.v\Checks\New Folder\Build Checks.dtsx"
i am getting warning
[Execute Process Task] Error: In Executing "F:\apps\SQL2005 (x86)\90\DTS\Binn\DTExec.exe" "dtexec /f "K:\John.v\Checks\New Folder\Build Checks.dtsx" " at "", The process exit code was "6" while the expected was "0".
please tell me how to pass arguments in correct way.
Monday, May 14, 2012 3:11 PMModerator
First, there's no need to pass "dtexec" as a parameter. Please remove that and try again.
Secondly, thanks for providing the full text of how you've configured the task.
Talk to me now on
Tuesday, May 15, 2012 6:59 AM
after removing "dtexec" it's working for me.